Обсуждение: 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