Installing Psql in parrot

Elvis Otieno — Sun, 11 Dec 2022 11:48:05 +0000

Having a problem installing psql in parrot or you did install but did not configure properly . here are major steps to follow.

Parrot psql installaton:
$ sudo apt-get update
$ sudo apt-get install postgresql postgresql-contrib libpq-dev
Enter y when prompted “Do you want to continue? [Y/n]” and wait as the installation completes.

Defining a user role
Postgres uses “roles” to aid in authentication and authorization. By default, Postgres creates a Postgres user and is the only user who can connect to the server.

We want to create our own superuser role to connect to the server.

For those running on elementary or parrot, run the following command first;
$ sudo service postgresql start
$ sudo -u postgres createuser --superuser $USER
Enter your desired password when prompted.

We then have to create a database with that $USER login name, this is what Postgres expects as default.
$ sudo -u postgres createdb $USER
Navigate to your home directory and enter the following command to create the .psql_history in order to save your history:
$ touch .psql_history
You can now connect to the Postgres server by typing :
$ psql

When facing an error, go through your terminal and navigate to:
$ ls /etc/apt/sources.list.d
that is
$ cd ..
then when @ sources.list.d :
$ sudo rm -r pgdg.list
When done repeat the first instruction shared in this article

See apt-secure(8) manpage for repository creation and user configuration details.

Elvis Otieno — Sat, 10 Dec 2022 16:02:49 +0000

When running throught that error just type the folllowing command in your terminal

sudo apt clean
cd /var/lib/apt
sudo mv lists lists.old
sudo mkdir -p lists/partial
sudo apt update

DEV Community: Elvis Otieno

Installing Psql in parrot

See apt-secure(8) manpage for repository creation and user configuration details.