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
Ответ на
Re: --//pgsql partitioning-///-------------------- (Ow Mun Heng)
Список
Дерево обсуждения
--//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 по дате отправления