Re: migrating to 9.2 created blank dbs

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

 





On Fri, May 1, 2015 at 6:39 PM, Marc Fromm <Marc.Fromm@xxxxxxx> wrote:

I setup a server running postgresql-server-9.2.10-2.el7_1.x86_64. After restoring my databases form a system running postgresql-server-8.1.23-10.el5_10 (created with pg_dumpall), several blank databases/entries were created.

When I list the database from the command line it shows several entries like:

                         |          |           |         |       | =T/postgres

 

After importing the databases is there a cleanup command of some sort?

These blank databases/entries do not show in PhpPgAdmin, yet my backup script tries to backup a database called “|”

 

Thanks

 

Marc

 

 


Did you run the 9.2 version of pg_dumpall or the 8.1 version to create your original dump file? You should run the 9.2 version on the 8.1 database if possible.

--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com

[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