On Mon, 2013-01-21 at 00:03 +0530, bhanu udaya wrote:
> Hello, Greetings !I am new to postgres and recently got migrated from
> oracle.I am trying to restore 9.5G database (1GB dumpfile) which has 500
> schemas with 1 lakh rows in each schema. Could take the data dump using
> pg_dump and it take
Hello, Greetings !I am new to postgres and recently got migrated from oracle.I
am trying to restore 9.5G database (1GB dumpfile) which has 500 schemas with 1
lakh rows in each schema. Could take the data dump using pg_dump and it takes
around 40 minutes. I tried to use pg_restore to restore this
Le 18/09/2010 22:09, Guillaume Lelarge a écrit :
> Le 17/09/2010 23:07, Derek Arnold a écrit :
>[...] I'll try on my Windows box but it won't be before
> tomorrow evening.
>
Works great.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
--
Sent via pgadmin-support mailing list (pgadm
Le 17/09/2010 23:07, Derek Arnold a écrit :
> Users at work frequently had issues with missing triggers and functions,
> and I finally dug down and took a look. I've been able to confirm that
> 8.4.4 pg_dump and pg_restore work as expected in Ubuntu 8.04 LTS. The
> server has the default (undefined
Users at work frequently had issues with missing triggers and functions,
and I finally dug down and took a look. I've been able to confirm that
8.4.4 pg_dump and pg_restore work as expected in Ubuntu 8.04 LTS. The
server has the default (undefined) setting for check_function_bodies.
But when r
Greetings,
I'm running into a wall trying to restore from a dumped database. This
database has a table with large objects, so I knew that I could not use
pg_dumpall, but rather pg_dump. The command that I used to produce the
dump was:
pg_dump -Ft -b -o sfee > /tmp/db.tar
where sfee is the name o
