On Tue, 29 Mar 2005 15:39:28 -0600, josue <[EMAIL PROTECTED]> wrote:
> Hello list,
>
> I need to upgrade my dbs from 743 to 801, current data size is around
> 5GB, I've tried this way:
>
> ./pg_dump -d dbtest -p 9980 | ./psql -d template1 -p 9981
>
> but is too slow, any idea or suggestion to
josue <[EMAIL PROTECTED]> writes:
> I did a pg_dumpall and this sentence to restore it back
>
> ./psql template1 -U postgres -p 9981 < /home2/tmp/dbtest.tar
You need to use 'pg_restore' for tar format dumps.
-Doug
---(end of broadcast)---
TIP 3: i
I did a pg_dumpall and this sentence to restore it back
./psql template1 -U postgres -p 9981 < /home2/tmp/dbtest.tar
and got this error
cannot allocate memory for output buffer
dbtest.tar is around 1.7 Gb, could anyone please bring some help to
update my 7.4 db to 8.0
Thanks in advance,
--
Sincer
Scott Marlowe wrote:
On Wed, 2005-03-30 at 01:33, Richard Huxton wrote:
josue wrote:
Hello list,
I need to upgrade my dbs from 743 to 801, current data size is around
5GB, I've tried this way:
./pg_dump -d dbtest -p 9980 | ./psql -d template1 -p 9981
but is too slow, any idea or suggestion to pro
On Wed, 2005-03-30 at 01:33, Richard Huxton wrote:
> josue wrote:
> > Hello list,
> >
> > I need to upgrade my dbs from 743 to 801, current data size is around
> > 5GB, I've tried this way:
> >
> > ./pg_dump -d dbtest -p 9980 | ./psql -d template1 -p 9981
> >
> > but is too slow, any idea or s
josue wrote:
Hello list,
I need to upgrade my dbs from 743 to 801, current data size is around
5GB, I've tried this way:
./pg_dump -d dbtest -p 9980 | ./psql -d template1 -p 9981
but is too slow, any idea or suggestion to properly upgrade my dbs, I
also have blobs stored there.
Try pg_dump foll
Hello list,
I need to upgrade my dbs from 743 to 801, current data size is around
5GB, I've tried this way:
./pg_dump -d dbtest -p 9980 | ./psql -d template1 -p 9981
but is too slow, any idea or suggestion to properly upgrade my dbs, I
also have blobs stored there.
Thanks in advance,
--
Sincer