On 16.03.2011 17:09, Kevin Grittner wrote:
Tambet Matiisentambet.matii...@gmail.com wrote:
Pre-live database is restored from live database dump every night.
How is that done? A single pg_dump of the entire live database
restored using psql? Are both database servers at the same
On 16.03.2011 22:29, Kevin Grittner wrote:
Tambet Matiisentambet.matii...@gmail.com wrote:
Yes, I use pg_dump on live server and the result is
rdiff-backupped into development server. Whole SQL dump is 12G
without compression and the rdiff delta is about 10-20MB every
day. Then I drop pre-live
Hi Kevin!
Thanks for your reply. You make me feel that this is more serious than I
thought.
This is development server, that is also used as pre-live server.
Pre-live database is restored from live database dump every night. So
far the errors have been in pre-live database, that's why I
Tambet Matiisen tambet.matii...@gmail.com wrote:
Pre-live database is restored from live database dump every night.
How is that done? A single pg_dump of the entire live database
restored using psql? Are both database servers at the same
PostgreSQL version?
So far the errors have been in
Tambet Matiisen tambet.matii...@gmail.com wrote:
On 16.03.2011 17:09, Kevin Grittner wrote:
Tambet Matiisentambet.matii...@gmail.com wrote:
Pre-live database is restored from live database dump every
night.
How is that done? A single pg_dump of the entire live database
restored using
Tambet Matiisen tambet.matii...@gmail.com wrote:
For a few days I've been getting this error from my nightly backup
script:
Warning: pg_dump: SQL command failed pg_dump: Error message from
server: ERROR: found toasted toast chunk for toast value 260340218
in pg_toast_260339342 pg_dump: