[rt-users] Postgres restore not restoring all the tables.

[Steve.Fraser at csiro.au]

Hi,

I'm looking for a solution into an issue I have encountered whilst trying to migrate the RT  and the postgres database from one Ubuntu server to a new Ubuntu server using Postgres.
The installation of RT, Apache2, Postgres have all gone  smoothly on the new server. An empty default, instance of RT is available via the webpage.

I have attempted to dump the current database and restore it onto the new server. Using the pg_dumpall and the pg_dump rtdb commands.
(ie) pg_dump rtdb >outputfile and pg_dumpall -clean -blob -format=C -U user rtdb >outputfile
The file sizes are significantly different pg_dumpall yields a 850Mb file whilst pg_dump rtdb has a 3.5Gb file

Restoring is where I encounter difficulties. I've tried both pg_restore and psql< inputfile
I
The outputfile from the pg_dump seems to go well, all the tickets are restored but none of the other tables. For instance the queues, groups and users tables are not populated with any data.

I've read the section on backup and restore from the RT Essentials book but still no joy.

Any advice, tips or recommendation greatly appreciated.



Regards
Steve

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110603/03fb121b/attachment.htm>