Re: migrating to 9.2 created blank dbs - Mailing list pgsql-admin

From Keith
Subject Re: migrating to 9.2 created blank dbs
Date
Msg-id CAHw75vvmsYV+DD_y4fTF7+0X8fT59_=1dFt3-gO1TNxZPu7sAA@mail.gmail.com
Whole thread Raw
In response to Re: migrating to 9.2 created blank dbs  (Marc Fromm <Marc.Fromm@wwu.edu>)
Responses Re: migrating to 9.2 created blank dbs
Re: migrating to 9.2 created blank dbs
List pgsql-admin
Going by your package name, I'm assuming you're running Red Hat or CentOS. Running both 8.1 and 9.2 at the same time on that OS could be a bit tricky and this isn't really the proper medium for discussing how to do so.

What you could do is copy the 9.2 pg_dumpall binary from the machine you have it installed on now and put it on the other machine. As long as they're the same OS/architecture that should work fine. The other option is to open up a network connection between the two systems and allow pg_dumpall from the 9.2 system to connect to 8.1 on the old system.


On Mon, May 4, 2015 at 10:59 AM, Marc Fromm <Marc.Fromm@wwu.edu> wrote:

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.rao@enterprisedb.com]
Sent: Saturday, May 02, 2015 12:11 AM
To: Keith Fiske
Cc: Marc Fromm; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] migrating to 9.2 created blank dbs

 


On Fri, May 1, 2015 at 6:39 PM, Marc Fromm <Marc.Fromm@wwu.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

 

 


pgsql-admin by date:

Previous
From: "Gilberto Castillo"
Date:
Subject: Re: migrating to 9.2 created blank dbs
Next
From: Tom Lane
Date:
Subject: Re: migrating to 9.2 created blank dbs