From: | Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu> |
---|---|
To: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>, Keith Fiske <keith(at)omniti(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: migrating to 9.2 created blank dbs |
Date: | 2015-05-04 14:59:21 |
Message-ID: | SN1PR0201MB1566B1E4175D6905894C10CB9DD20@SN1PR0201MB1566.namprd02.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I ran vacuumdb --all --analyze but the blank entries remain in the list of databases.
How do I run 9.2 version of pg_dumpall on a system running postgresql 8.1?
Thanks for the replies.
Marc
From: Raghavendra [mailto:raghavendra(dot)rao(at)enterprisedb(dot)com]
Sent: Saturday, May 02, 2015 12:11 AM
To: Keith Fiske
Cc: Marc Fromm; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] migrating to 9.2 created blank dbs
On Fri, May 1, 2015 at 6:39 PM, Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu<mailto:Marc(dot)Fromm(at)wwu(dot)edu>> 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 “|”
Is this behaviour, after you have imported the databases and ANALYZE cluster ?. By-chance if you have missed to performe ANALYZE on post import, please do it.
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.
+1
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Keith | 2015-05-04 15:18:17 | Re: migrating to 9.2 created blank dbs |
Previous Message | Jan Lentfer | 2015-05-04 12:17:14 | Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times |