trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Title: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6

Hi everybody,

I just finished installing postgres 8.3.6 and was
able to start it.  The log file reads:

  [2009-02-22 00:27:01.824 PST] < 11543  2009-02-22 00:27:01 PST >LOG:  database system was interrupted; last known up at 2009-02-22 00:25:04 PST
  [2009-02-22 00:27:01.825 PST] < 11543  2009-02-22 00:27:01 PST >LOG:  database system was not properly shut down; automatic recovery in progress
  [2009-02-22 00:27:01.827 PST] < 11543  2009-02-22 00:27:01 PST >LOG:  record with zero length at 13D/F78D2378
  [2009-02-22 00:27:01.827 PST] < 11543  2009-02-22 00:27:01 PST >LOG:  redo is not required
  [2009-02-22 00:27:01.880 PST] < 11546  2009-02-22 00:27:01 PST >LOG:  autovacuum launcher started
  [2009-02-22 00:27:01.881 PST] < 11542  2009-02-22 00:27:01 PST >LOG:  database system is ready to accept connections

While in postgres's home directory, I issued a command:
  ./bin/psql -f PastLogs/dumpall.out postgres
which is almost verbatim from the man page.  When I had
.pgpass file, it told me:
  psql: FATAL:  password authentication failed for user "postgres"
When I got rid of it, it asked me for one.  Whatever I gave was
no avail.  The password it is asking is not login password?

Can somebody please help?

Thank you.

Regards,

Tena Sakai
tsakai@xxxxxxxxxxxxxx


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux