Lists of cy tagged as 'postgresql'
Private lists of cy are not displayed.
-
pg_dump -Fc -b -U username databasename > data.bak
-
pg_restore -O -d databasename -U username 'database.bak' -c
Step 1
1.1 sudo less /etc/postgresql/8.4/main/pg_hba.conf
1.2 local all sameuser trust
1.3 local all all trust
1.4 host all all 127.0.0.1/32 trust
1.5 host all all ::1/128 trust
Step 2
2.1 sudo /etc/init.d/postgresql-8.4 restart
Step 3
3.1 Set password for user postgres
References
Ubuntu Help - PostgreSQL
Postgres authentication failure