[ADMIN] Problem with pg_dump

Hi All, I am a developer of a product that uses a postgresql database (currently version 8.2.3.1). We dump the database using pg_dumpall. We are finding data corruption in the dump files about twice a month with a few thousand installations. I have been able to track down the data corruption

[ADMIN] Problem with pg_dump

Problem with pg_dump on PostgreSQL 8.05. How to solve this problem. Thank you. $ pg_dump dbname > 080349.sql pg_dump: socket not open pg_dump: SQL command to dump the contents of table "t_visit_service" failed: PQendcopy() failed. pg_dump: Error message from server: socket not open pg_dump: The co

[ADMIN] problem with pg_dump

Hi all, We are using pg as db for many erp installations. In general it is working great. But at the monet I have problem (I think it is database corrupted, but I am not sure) by running pg_dump. I receive this message: pg_dump acc01 > dmpacc01 pg_dump: query to obtain list of data types failed: ER

Re: [ADMIN] Problem with pg_dump

On Sat, Mar 11, 2006 at 11:56:55PM -0800, Sothorn Rordkongthee wrote: > $ pg_dump dbname > 080349.sql > pg_dump: socket not open Do you get this error every time you run pg_dump? Do you see any errors in the server logs? -- Michael Fuhr ---(end of broadcast)

[ADMIN] Problem with pg_dump / pg_restore

Hi everybody, I have a problem with dump / restore commands on PostgreSQL: pg_dump doesn't care about objects dependencies: - I create a view V1 on a table and then another view V2 on the same table - I modify V1 to use V2 pg_dump doesn't detect that V1 is using V2. So the command

[ADMIN] Problem with pg_dump / pg_restore

Hi everybody, I have already posted this message, but nobody answered to it. I can't imagine that I'm the first one who have this problem, so I post it again: I have a problem with dump / restore commands on PostgreSQL: pg_dump doesn't care about views dependencies: - I create a view V1

[ADMIN] problem with pg_dump - reg.

Dear Group, Thanks for all your support to my previous postings. I am currently using Postgresql 7.3.4-2PGDG. The problem I am facing is that when I take a dump of the DB using pg_dump and restore it using the cat pg_dump_file |psql dbname, I find that some views and funct

Re: [ADMIN] Problem with pg_dump / pg_restore

Hi Armel, I have searched hi and low on the net to try to get answers regarding pg_dump and pg_restore, specifically to be allow them to run with crontab on the red hat servers that I look after as programmer and general IT dogs body. I would appear from the general brevity of the replys ; that

Re: [ADMIN] Problem with pg_dump / pg_restore

el (and again, sorry for my poor english!) -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] la part de Mark Carew Envoyé : vendredi 28 novembre 2003 23:12 À : [EMAIL PROTECTED] Objet : Re: [ADMIN] Problem with pg_dump / pg_restore Hi Armel, I have searched hi and

Re: [ADMIN] Problem with pg_dump / pg_restore

Hi Armel, Why not do a structure only dump to plain text and see if you can use that as your start .sql ext file for 'psql -e .. etc'. Eliminates the necessity to have an active client side data dictionary. BTW, your english is fine. Regards markcarew@ magicwanddept.com.au ---

Re: [ADMIN] Problem with pg_dump / pg_restore

i 1 décembre 2003 10:00 À : [EMAIL PROTECTED] Objet : Re: [ADMIN] Problem with pg_dump / pg_restore Hi Armel, Why not do a structure only dump to plain text and see if you can use that as your start .sql ext file for 'psql -e .. etc'. Eliminates the necessity to have an active

[ADMIN] problem with pg_dump and pg_restore

Hi I try to move my datas from a postresql 7.3.2 to a postgresql 7.4.1. The database was dumped with: pg_dumpall -g GLOBALobjects.sql pg_dump -s DATABASE > DBschema.sql pg_dump -Fc DATABASE > DBdata.tar and rebuilt on the new system with: createdb DATABASE psql DATABASE < GLOBALobject

Re: [ADMIN] problem with pg_dump and pg_restore

...and on Wed, Apr 21, 2004 at 02:46:54PM +0200, Fischer Ulrich used the keyboard: > Hi > > I try to move my datas from a postresql 7.3.2 to a postgresql 7.4.1. The > database was dumped with: > > pg_dumpall -g GLOBALobjects.sql > pg_dump -s DATABASE > DBschema.sql > pg_dump -Fc DATABASE >

Re: [ADMIN] problem with pg_dump and pg_restore

The schema/data separation is higly recommended in the HowTo of tsearch2. Thanks for your idea, I'l try it! Ulrich Grega Bremec wrote: ...and on Wed, Apr 21, 2004 at 02:46:54PM +0200, Fischer Ulrich used the keyboard: Hi I try to move my datas from a postresql 7.3.2 to a postgresql 7.4.1. The

Re: [ADMIN] problem with pg_dump and pg_restore

um.si> cc: [EMAIL PROTECTED] Sent by: Subject: Re: [ADMIN] problem with pg_dump and pg_restore [EMA

Re: [ADMIN] problem with pg_dump and pg_restore

Sent: Wednesday, April 21, 2004 12:06 PM To: Grega Bremec Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Fischer Ulrich Subject: Re: [ADMIN] problem with pg_dump and pg_restore When I tried to use the 7.3.2 dump, and use 7.4.1 import, I had several issues- mostly with data. I actually had to dump wit