Potentially serious migration issue from 7.1.3 to 7.2 (or 7.3)

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Potentially serious migration issue from 7.1.3 to 7.2 (or 7.3)
Дата
Msg-id 3DF7D440.4070308@commandprompt.com
обсуждение исходный текст
Ответы Re: Potentially serious migration issue from 7.1.3 to 7.2  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
Hello,

   We are experiencing some very strange behavior with a restore that we
are trying to do. The command we are using to do the backup is:

   /bin/su - larry -c \"/usr/local/pgsql/bin/pg_dump $dbname
--superuser=larry -o --format=c -b -f /backups/$dbname.`date +%a`.tar.gz

   The backups run, we appear unable to restore them. The command we are
using to try and restore the information is:

/usr/local/pgsql/bin/pg_restore -d dominion dominion.Fri.tar

When we run pg_restore we get the following -- thoughts???:

   DEBUG:  connection: host=[local] user=postgres database=dominion
DEBUG:  InitPostgres
DEBUG:  StartTransactionCommand
DEBUG:  query: select getdatabaseencoding()
DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: SELECT version()
DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: select usesuper from pg_user where usename = 'postgres'
DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: --
-- Selected TOC Entries:
--
--
-- TOC Entry ID 2 (OID 0)
--
-- Name: Max OID Type: <Init> Owner:
-- Data Pos: 0 (Length 0)
--

CREATE TEMPORARY TABLE pgdump_oid (dummy int4);
DEBUG:  ProcessUtility: --
-- Selected TOC Entries:
--
--
-- TOC Entry ID 2 (OID 0)
--
-- Name: Max OID Type: <Init> Owner:
-- Data Pos: 0 (Length 0)
--

CREATE TEMPORARY TABLE pgdump_oid (dummy int4);
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query:
COPY pgdump_oid WITH OIDS FROM stdin;
DEBUG:  ProcessUtility:
COPY pgdump_oid WITH OIDS FROM stdin;
pq_recvbuf: unexpected EOF on client connection
DEBUG:  CommitTransactionCommand
pq_flush: send() failed: Broken pipe
pq_recvbuf: unexpected EOF on client connection
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)

--
<COMPANY>CommandPrompt    - http://www.commandprompt.com    </COMPANY>
<CONTACT>       <PHONE>+1.503.222-2783</PHONE>          </CONTACT>


В списке pgsql-general по дате отправления:

Предыдущее
От: Toby Tremayne
Дата:
Сообщение: Re: refursor from dynamic query
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [ADMIN] 7.2.x -> 7.3 upgrade docs?