Re: restore a pg_dumpall only breaks

> A dump from 9.2 is no sure thing to restore into an 8.1 database; there may be SQL syntax in it that 8.1 doesn't understand. Have you checked for errors during the restore?

After the last successful database restore from the pg_dumpall file this is displayed on the ssh session.

psql:pg_dbs.bkp:1029100: \connect: invalid connection option "-reuse-previous"

In the pg_dumpall file the \connect statement is different than the databases the fully restore

\connect -reuse-previous=on "dbname='sfr2002-2003'"

Successful restores only have \connect name_of_database. Not sure why the above one has the dbname in quotes.

Where else can I check for errors?

Thanks
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, November 23, 2016 6:05 PM
To: Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] restore a pg_dumpall only breaks

Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu> writes:
> If I use the command "pg_dumpall -c -U postgres | gzip > pg_dbs.gz" to create a backup of all databases from "postgresql 9.2" and then restore it to "postgresql 8.1" on a different server only about the first half of the databases are restored with their tables and records. The second half, only the databases themselves are created but with no tables and no records.

A dump from 9.2 is no sure thing to restore into an 8.1 database; there may be SQL syntax in it that 8.1 doesn't understand. Have you checked for errors during the restore?

regards, tom lane