pg_dump native format will not restore correctly

Поиск
Список
Период
Сортировка
Искать
От
Scot Kreienkamp
Тема
pg_dump native format will not restore correctly
Дата
Msg-id
37752EAC00ED92488874A27A4554C2F303DC7209@lzbs6301.na.lzb.hq
Ответ на
Список
Дерево обсуждения
--//pgsql partitioning-///-------------------- shahrzad khorrami <shahrzad.khorrami@gmail.com>
Re: --//pgsql partitioning-///-------------------- Vick Khera <vivek@khera.org>
Re: --//pgsql partitioning-///-------------------- "Ow Mun Heng" <ow.mun.heng@wdc.com>
pg_dump native format will not restore correctly "Scot Kreienkamp" <SKreien@la-z-boy.com>
Re: pg_dump native format will not restore correctly Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump native format will not restore correctly "Scot Kreienkamp" <SKreien@la-z-boy.com>
Re: pg_dump native format will not restore correctly Sam Mason <sam@samason.me.uk>
Re: pg_dump native format will not restore correctly "Scot Kreienkamp" <SKreien@la-z-boy.com>
Re: pg_dump native format will not restore correctly Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump native format will not restore correctly "Scot Kreienkamp" <SKreien@la-z-boy.com>
Re: --//pgsql partitioning-///-------------------- Wojtek <foo@twine.pl>
Hi everyone,

I have successfully been doing text based backups and restores to a few
servers for reporting and testing purposes for a few years now.  Due to
growth in the database I am switching to the native format backup and
using pg_restore to restore the database.  The problem I've run into is
that at least one table is inaccessible after the restore finishes.  Any
queries to that table just hang.  Other tables seem to work ok.  I have
no idea why.

Here's my backup command:
/usr/bin/pg_dump -U postgres rms-prod -F c -f $WALPATH/rms-prod.pgc

Here's my restore command:
pg_restore -v -U postgres -h $PGHOST --exit-on-error -d rms-prod
$WALPATH/rms-prod.pgc

However, when I do a text based backup and subsequent restore,
everything works just fine.

I'm currently running 8.3.7 on all my servers.  

Thanks for the help.

Scot Kreienkamp
skreien@la-z-boy.com


В списке pgsql-general по дате отправления
От: Tom Lane
Дата:
От: Tom Lane
Дата:
FAQ