Query for importing and exporting data from a database

"Yateen Joshi" <yjoshi@starentnetworks.com> writes:

Link: File-List

Hi,

I am using postgres 7.4.2 on Solaris. My unix system does not place a
limitation of 2 GB on file size. If I export a data from my database that
causes the file size to be more than 2 GB, then that export fails (and
vice versa for importing, i.e. if the file size is more than 3 GB, it can
not import). Two questions -

Why does this happen?

Is there any way to avoid this?

Probably, your Postgres was not compiled with the LARGEFILE option (I
forget exactly what it's called).

You may be able to work around it by doing something like:

pg_dump -t mytable mydb | cat > output.sql

-Doug

Thanks for that!
Is there any way I can check if my Postgres was compiled using that
option or not?

Yateen V. Joshi

-----Original Message-----
From: Douglas McNaught [mailto:doug@mcnaught.org]
Sent: Thursday, May 26, 2005 8:49 PM
To: Yateen Joshi
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Query for importing and exporting data from a
database

"Yateen Joshi" <yjoshi@starentnetworks.com> writes:

Link: File-List

Hi,

I am using postgres 7.4.2 on Solaris. My unix system does not place a
limitation of 2 GB on file size. If I export a data from my database

that

causes the file size to be more than 2 GB, then that export fails (and
vice versa for importing, i.e. if the file size is more than 3 GB, it

can

not import). Two questions -

Why does this happen?

Is there any way to avoid this?

Probably, your Postgres was not compiled with the LARGEFILE option (I
forget exactly what it's called).

You may be able to work around it by doing something like:

pg_dump -t mytable mydb | cat > output.sql

-Doug