Re: [ADMIN] pg_dump max file size exceeded

2002-03-19 Thread Jyry Kuukkanen
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

Re: [ADMIN] pg_dump max file size exceeded

2002-03-19 Thread Tom Lane
"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

Re: [ADMIN] pg_dump max file size exceeded

2002-03-19 Thread Tuna Chatterjee
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

Re: [ADMIN] pg_dump max file size exceeded

2002-03-19 Thread Nick Fankhauser
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/ > ---

[ADMIN] pg_dump max file size exceeded

2002-03-19 Thread Fred Moyer
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)-

Re: [ADMIN] error during copying .txt file

2002-03-19 Thread Jean-Luc Lachance
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

Re: [ADMIN] error during copying .txt file

2002-03-19 Thread bangh
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

[ADMIN] error during copying .txt file

2002-03-19 Thread rama tulasi
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

Re: [ADMIN] database quotes - oops I'm talking rubbish

2002-03-19 Thread Henshall, Stuart - WCP
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

Re: [ADMIN] database quotes

2002-03-19 Thread Henshall, Stuart - WCP
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