Postgres Pro
Downloads
Home   >   mailing lists

Query for importing and exporting data from a database - Mailing list pgsql-general

From Yateen Joshi
Subject Query for importing and exporting data from a database
Date
Msg-id FF851C7EEB75954F9BCFB5CA117AB1EC01F19911@delta.nulinkinc.com
Whole thread Raw
Responses Re: Query for importing and exporting data from a database  (Douglas McNaught <doug@mcnaught.org>)
List pgsql-general
Tree view

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?

 

Basically, I want to export huge chunk of data to files and then import the same, please help me.

 

Thanks and regards,

 

Yateen V. Joshi

 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bgwriter--- BufferSync() and StrategyStatsDump()
Next
From: bvb
Date:
Subject: unsupported frontend protocol