Content-Type: text/plain; charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2098\))
Subject: Re: migrating to 9.2 created blank dbs
From: Jeff Frost <jeff@pgexperts.com>
In-Reply-To: 
 <SN1PR0201MB1566898FF19961BBC03A67999DD20@SN1PR0201MB1566.namprd02.prod.outlook.com>
Date: Mon, 4 May 2015 10:12:40 -0700
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <C047F894-F87E-4D39-A2AB-8276C52DE2E5@pgexperts.com>
References: 
 <DM2PR0201MB10705274CE0678AC115347AF9DD50@DM2PR0201MB1070.namprd02.prod.outlook.com>
 <CAG1_KcCzq71a5F-ukHvQB4q-y34R1C=tsVYKQcZJgJr5orgzEA@mail.gmail.com>
 <CA+h6AhjFKxWzr+su4w=fchtgOtZHeOc4s0dg7KVfcp7kVtfEkA@mail.gmail.com>
 <SN1PR0201MB1566B1E4175D6905894C10CB9DD20@SN1PR0201MB1566.namprd02.prod.outlook.com>
 <CAHw75vvmsYV+DD_y4fTF7+0X8fT59_=1dFt3-gO1TNxZPu7sAA@mail.gmail.com>
 <32752.1430755649@sss.pgh.pa.us>
 <SN1PR0201MB15663C77E1FD1FFB3CA0DE049DD20@SN1PR0201MB1566.namprd02.prod.outlook.com>
 <12B3F4BE-B5B0-4955-808F-3649EC1F7A00@pgexperts.com>
 <SN1PR0201MB1566898FF19961BBC03A67999DD20@SN1PR0201MB1566.namprd02.prod.outlook.com>
To: Marc Fromm <Marc.Fromm@wwu.edu>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

My guess is the script is just using:

=05psql -l | awk =E2=80=98{print $1}=E2=80=99

To get the list of DBs to backup instead of:

=05psql -c =E2=80=9CSELECT datname from pg_database=E2=80=9D


Can you share the script?


> On May 4, 2015, at 9:43 AM, Marc Fromm <Marc.Fromm@wwu.edu> wrote:
>=20
> That could be correct that I am misinterpreting the output. Why would the=
 backup script try to backup these blank entries as a database backup file =
called "|"?
>=20
> Thanks
>=20
> -----Original Message-----
> From: Jeff Frost [mailto:jeff@pgexperts.com]=20
> Sent: Monday, May 04, 2015 9:41 AM
> To: Marc Fromm
> Cc: Tom Lane; Keith; Raghavendra; Keith Fiske; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] migrating to 9.2 created blank dbs
>=20
> Any chance you=E2=80=99re just misinterpreting the new more verbose outpu=
t of psql=E2=80=99s \l command?
>=20
> Nowadays, it looks like this:
>=20
> postgres=3D# \l
>                                List of databases
>     Name      |   Owner    | Encoding | Collate | Ctype |   Access privil=
eges
> ---------------+------------+----------+---------+-------+--------------
> ---------------+------------+----------+---------+-------+---------
> postgres      | postgres   | UTF8     | C       | C     |
> template0     | postgres   | UTF8     | C       | C     | =3Dc/postgres  =
        +
>               |            |          |         |       | postgres=3DCTc/=
postgres
> template1     | postgres   | UTF8     | C       | C     | =3Dc/postgres  =
        +
>               |            |          |         |       | postgres=3DCTc/=
postgres
> (4 rows)
>=20
> But there are still only 3 databases being listed above.=20=20
>=20
>> On May 4, 2015, at 9:24 AM, Marc Fromm <Marc.Fromm@wwu.edu> wrote:
>>=20
>> Running the select statement gives me a list of all my databases. The on=
ly thing that looks suspicious are a few databases have stuff like this in =
the datacl column " {postgres=3DCT/postgres,=3DT/postgres}". The number of =
databases with that is suspiciously equal to the number of blanks created.
>>=20
>> Marc
>>=20
>> -----Original Message-----
>> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>> Sent: Monday, May 04, 2015 9:07 AM
>> To: Keith
>> Cc: Marc Fromm; Raghavendra; Keith Fiske; pgsql-admin@postgresql.org
>> Subject: Re: [ADMIN] migrating to 9.2 created blank dbs
>>=20
>>> 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.=20
>>>> After restoring my databases form a system running
>>>> postgresql-server-8.1.23-10.el5_10 (created with pg_dumpall),=20
>>>> several blank databases/entries were created.
>>=20
>> FWIW, this seems to match a symptom we've heard of occasionally in which=
 the source server's catalogs are corrupted.  If the 8.1 server is still on=
line it would be interesting to connect to it manually and see what you get=
 from "select * from pg_database=E2=80=9D.
>=20
>=20

---
Jeff Frost <jeff@pgexperts.com>
CTO, PostgreSQL Experts, Inc.
Phone: 1-888-PG-EXPRT x506
FAX: 415-762-5122
http://www.pgexperts.com/=20


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin