pg_restore ERROR

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

 



After running pg_dumpall on my database cluster like this:

 

$PGBIN/pg_dumpall –c -U ipscdb | gzip > /var/db/pgsql_bkp/pg_dump_file.gz

 

I subsequently delete the PGDATA directory for the backed up database and initialize a new database.  Next I attempt to run the restore using initialized database like this:

 

cat /var/db/pgsql_bkp/pg_dump_file.gz | gunzip | $PGBIN/psql postgres > /dev/null

 

This results in a couple of error messages:

 

ERROR:  current user cannot be dropped

ERROR:  role "ipscdb" already exists

 

Since I ran initdb to initialize my database after the pg_dumpall as “ipscdb” user, and subsequently am running the restore as “ipscdb” user, it does make sense that I see these errors.  The first one is caused by the –c switch on pg_dumpall which generates the script to drop all database objects before restore is done.  The second is a consequence of the first one – script is attempting to create a role, which already exists.

 

My questions are:

1)       What would be the right way to do this?  (other than pg_restore with the create option)

2)       Does the restore go forward despite the two errors shown above – meaning that I can pretty much ignore these errors?

 

Thanks in advance,

~george


[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