On Tue, 2002-03-19 at 16:39, Fred Moyer wrote:
> hey fellow pg'ers.
>
> ran time pg_dump -c --verbose database > datafile.psql from the command line
> and got a file size limit exceeded. datafile.psql stopped at 2 gigs. any
> ideas how to exceed that limit?
>
> redhat 7.2, 2.4.9-31 kernel
> post
"Fred Moyer" <[EMAIL PROTECTED]> writes:
> ran time pg_dump -c --verbose database > datafile.psql from the command line
> and got a file size limit exceeded. datafile.psql stopped at 2 gigs. any
> ideas how to exceed that limit?
> redhat 7.2, 2.4.9-31 kernel
[ scratches head... ] If you were
hi fred,
i ran into the same problem a couple of weeks ago and realized that the
problem was where the dump was being put instead of trying to deal with
the size of the file.
go ahead and do type 'df' at the command prompt and look at the space
allocated to your partitions. do the database dump
Pipe it into gzip:
pg_dump db_name|gzip>dbname.sql.gz
NickF
--
Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
> ---
hey fellow pg'ers.
ran time pg_dump -c --verbose database > datafile.psql from the command line
and got a file size limit exceeded. datafile.psql stopped at 2 gigs. any
ideas how to exceed that limit?
redhat 7.2, 2.4.9-31 kernel
postgres 7.2
---(end of broadcast)-
Rama,
Are psql and the postgres server on the same machine?
If so, make sure the file is world readable (and the directories as
well).
If not, try:
psql -h host -d database -c "copy hour from stdin delimiters ',';" <
/home/staff/band.txt
rama tulasi wrote:
>
> hi,
> can you help me to solve th
set the folders' as well as file's permission
chmod o+x /home
chmod o+x /home/staff
chmod o+r band.txt
Banghe
rama tulasi wrote:
> hi,
> can you help me to solve this problem..
> copy hour from '/home/staff/band.txt' using delimiters
> ',';
> ERROR: COPY command, running in backend with
> effe
hi,
can you help me to solve this problem..
copy hour from '/home/staff/band.txt' using delimiters
',';
ERROR: COPY command, running in backend with
effective uid 26, could not open file
'/home/staff/band.txt' for reading. Errno =
Permission denied (13).
i am very greatful to you if you able to
Sorry to reply to myself
Ignore me sorry I'm talking rubbish. I was forgetting all processes would be
owned by the postgres user and not the database user. (The oid2name stuff is
still correct)
- Stuart
> -Original Message-
> From: Hernan Nuñez [mailto:[EMAIL PROTECTED]]
> Sent: 18 March
The name is the oid of the database.
The oid2name in contrib can help here.
However this doesn't solve the problem of new information going into the WAL
files before being written into the actual tables.
I am unsure what would happen if the database where unable to write to table
files information
10 matches
Mail list logo