zipperer / migrate_database_with_michael

0 stars 0 forks source link

Execute commands to log in to postgres instance #8

Closed zipperer closed 7 months ago

zipperer commented 7 months ago

Perform these steps from postgres_script.txt

$ apt-get update
$ top
$ ps
$ ps | grep -i postgres
$ ls -ltr /etc/postgresql
$ apt-get install postgresql # answer prompts about new libraries and timezones
$ ls -ltr /etc/postgresql # files are here
open /etc/postgresql/NUMBER/main/pg_hba.conf
replace 'peer' with 'trust'. save and exit.
$ service postgresql start

= log in to postgres instance =

$ psql --username postgres --dbname postgres
zipperer commented 7 months ago

We did this during #2 .