From: | Keith <keith(at)keithf4(dot)com> |
---|---|
To: | Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu> |
Cc: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>, Keith Fiske <keith(at)omniti(dot)com>, "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 15:18:17 |
Message-ID: | CAHw75vvmsYV+DD_y4fTF7+0X8fT59_=1dFt3-gO1TNxZPu7sAA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)Fromm(at)wwu(dot)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(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> 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 | Gilberto Castillo | 2015-05-04 16:05:39 | Re: migrating to 9.2 created blank dbs |
Previous Message | Marc Fromm | 2015-05-04 14:59:21 | Re: migrating to 9.2 created blank dbs |