pg_dumpall and large flat file 
Author Message
 pg_dumpall and large flat file

This is a multi-part message in MIME format.

------=_NextPart_000_001A_01C2BCAE.24B9E850
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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,

Tel: +44 (0) 1293 864 303
Thermeon Europe e-Card: gbjk

------=_NextPart_000_001A_01C2BCAE.24B9E850
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Diso-8859-=
1">
<TITLE>Gareth Stationery</TITLE>

<META content=3D"MSHTML 6.00.2800.1126" name=3DGENERATOR></HEAD>
<BODY style=3D"FONT-SIZE: 10pt; COLOR: #808080; FONT-FAMILY: Tahoma"=20
background=3D"">
<DIV><SPAN class=3D093234815-15012003>Hey everyone.</SPAN></DIV>
<DIV><SPAN class=3D093234815-15012003></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D093234815-15012003>We've got to re-install a server shor=
tly,=20
and I'm trying to do a dry run of reloading their data onto a similar=20
server.</SPAN></DIV>
<DIV><SPAN class=3D093234815-15012003>It's Postgres 7.1.3 on Redhat Linux (=
 6.2 or=20
7.2 - not too important )</SPAN></DIV>
<DIV><SPAN class=3D093234815-15012003>We used pg_dumpall &gt; large to crea=
te a=20
file that's just under 1Gb in size.</SPAN></DIV>
<DIV><SPAN class=3D093234815-15012003>Obviously there's no vi'ing this and =
little=20
hope of cat&nbsp;| less.</SPAN></DIV>
<DIV><SPAN class=3D093234815-15012003>We can split the file with split&nbsp=
;-l=20
100000 if we need to.</SPAN></DIV>
<DIV><SPAN class=3D093234815-15012003></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D093234815-15012003>We want to now reload this database=
=20
cluster.</SPAN></DIV>
<DIV><SPAN class=3D093234815-15012003></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D093234815-15012003>The questions:</SPAN></DIV>
<DIV><SPAN class=3D093234815-15012003></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D093234815-15012003>1) Is pg_dumpall the best way of doin=
g this=20
( it's the only way I can find )</SPAN></DIV>
<DIV><SPAN class=3D093234815-15012003>2) Is pgsql -f large template1 the be=
st way=20
of reloading it</SPAN></DIV>
<DIV><SPAN class=3D093234815-15012003>3) How long should it take ( 128mb of=
 ram,=20
1ghz processor ) -&nbsp;roughly ( hours - days!? :-D )</SPAN></DIV>
<DIV><SPAN class=3D093234815-15012003></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D093234815-15012003>Thanks everyone</SPAN></DIV>
<DIV><SPAN class=3D093234815-15012003></SPAN>&nbsp;</DIV>
<DIV=20
style=3D"FONT-WEIGHT: normal; COLOR: #999999; FONT-FAMILY: Tahoma; size: 12=
px">Gareth=20
Kirwan<BR>Programming &amp; Development,<BR>Thermeon Europe Ltd,<BR><A=20
style=3D"FONT-WEIGHT: normal; COLOR: #666666; FONT-FAMILY: Tahoma; size: 12=
px"=20

: +44=20
(0) 1293 864 303<BR><A=20
style=3D"FONT-WEIGHT: normal; COLOR: #666666; FONT-FAMILY: Tahoma; size: 12=
px"=20
href=3D" http://www.***.com/ ; target=3D_blank>T=
hermeon=20
Europe e-Card: gbjk </A></DIV><FONT color=3D#808080></FONT></BODY></HTML>

------=_NextPart_000_001A_01C2BCAE.24B9E850--



Mon, 04 Jul 2005 00:18:16 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Help With File Size Limitations - Large Flat Files

2. Help With File Size Limitations - Large Flat Files

3. Help With File Size Limitations - Large Flat Files

4. Help With File Size Limitations - Large Flat Files

5. Accessing Flat files through DTS Flat File OLE DB Provider

6. What is fastest way to extract large table to flat text file

7. large flat-file database

8. Extracting large volumes of data from oracle to flat files - Poor Performance

9. Reading flat files(DAT Files) from Foxpro Program

10. bringing portal data back into related file to create a flat file

11. Addresses and Contacts: flat file vs. related files

12. Flat file/form data to related files?


 
Powered by phpBB® Forum Software