Re: [ADMIN] pg_restore and transaction id wraparound

2003-12-01 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (ow) wrote: > --- Tom Lane <[EMAIL PROTECTED]> wrote: >> Actually you can only have 4 billion SQL commands per xid, because the >> CommandId datatype is also just 32 bits. I've never heard of anyone >> running into that limit, though. >

Re: [ADMIN] db-recovery after update 7.1 -> 7.4 failed

2003-12-01 Thread Bryan Encina
Hi Dominique, >ERROR:  literal carriage return found in data >HINT:  Use "\r" to represent carriage return. >CONTEXT:  COPY netjuke_tracks, line 3312: "3196 940 335 4 >21 Things I Want In A Lover 4991999 >207 1   20022003-05-16 21:24:08+02  192 44100 >MPEG ..." > >"phpbb_po

[ADMIN] unsubscribe

2003-12-01 Thread Hector
 

Re: [ADMIN] db-recovery after update 7.1 -> 7.4 failed

2003-12-01 Thread Oliver Elphick
On Mon, 2003-12-01 at 09:35, Dominique Fenenr wrote: > Hi all, > > I recently upgraded postgresql from 7.1 to 7.4. I did a > > pg_dumpall > backup > > then installed the new version and tried to recover my data with > > psql template1 > But something went wrong. The log shows the following:

[ADMIN] db-recovery after update 7.1 -> 7.4 failed

2003-12-01 Thread Dominique Fenenr
Hi all, I recently upgraded postgresql from 7.1 to 7.4. I did a pg_dumpall > backup then installed the new version and tried to recover my data with psql template1

Re: [ADMIN] Problem with pg_dump / pg_restore

2003-12-01 Thread Armel HERVE
Hi Mark, in fact, the problem is in the structure backup: this command doesn't care about views dependencies. It take views in creation order to put its in the .sql. So I have to reorder manually this view creations. I made a view (another...) to look for dependencies. Maybe it's the good way. T

Re: [ADMIN] Problem with pg_dump / pg_restore

2003-12-01 Thread Mark Carew
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] eRserver

2003-12-01 Thread James Cooper
I can't comment on exactly how eRserver benchmarks. But your comments on Java are sadly misplaced, maybe '95 esque. You'll find that allot of the misconceptions around java as a language stem from crtique with in roots from the frist widely accessible virtual machine 1.0.2. Many of the so call

Re: [ADMIN] eRserver (slightly offtopic)

2003-12-01 Thread Grega Bremec
...and on Fri, Nov 28, 2003 at 03:27:56PM -0500, Renney Thomas used the keyboard: > > I would like to hear about any issues related to erserver. I was a > little concerned about its use of Java. Java is a great tool for > creating application frameworks for the payroll department, but using it

Re: [ADMIN] Problem with pg_dump / pg_restore

2003-12-01 Thread Armel HERVE
Hi Mark, Thanks for your answers: you're the first one to do it! your anwers confirm things than I did'nt want to do : make my own structure backup... But it is very strange that pg_dump/pg_restore doesn't works in all cases. I'll do my own backyp app... ;-( Thanks Armel (and again, sorry fo