From: | "Gareth Kirwan" <gbjk(at)thermeoneurope(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | pg_dumpall and large flat file |
Date: | 2003-01-15 15:52:43 |
Message-ID: | 001901c2bcae$24b9e850$55eaa8c0@gbjk1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Gareth StationeryHey everyone.
We've got to re-install a server shortly, and I'm trying to do a dry run of
reloading their data onto a similar server.
It's Postgres 7.1.3 on Redhat Linux ( 6.2 or 7.2 - not too important )
We used pg_dumpall > large to create a file that's just under 1Gb in size.
Obviously there's no vi'ing this and little hope of cat | less.
We can split the file with split -l 100000 if we need to.
We want to now reload this database cluster.
The questions:
1) Is pg_dumpall the best way of doing this ( it's the only way I can find )
2) Is pgsql -f large template1 the best way of reloading it
3) How long should it take ( 128mb of ram, 1ghz processor ) - roughly (
hours - days!? :-D )
Thanks everyone
Gareth Kirwan
Programming & Development,
Thermeon Europe Ltd,
gbjk(at)thermeoneurope(dot)com
Tel: +44 (0) 1293 864 303
Thermeon Europe e-Card: gbjk
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-01-15 16:19:29 | Re: Problems with PGOPTIONS |
Previous Message | Tom Lane | 2003-01-15 15:45:52 | Re: Query failing with strange error. |