Re: [ADMIN] Sender: owner-pgsql-admin@postgreSQL.org

2000-02-21 Thread Bruce Momjian
No problem with taht size. > Hi > > I'm new here and now i'm building a large DB (20GB data). I was looking around and i >can't find any info if Postgres can manipulate so large DB with falls and data loss. > I have found only info that postgres can manipulate DB larger than maximum file size.

[ADMIN] Sender: owner-pgsql-admin@postgreSQL.org

2000-02-21 Thread ice . planet
Hi I'm new here and now i'm building a large DB (20GB data). I was looking around and i can't find any info if Postgres can manipulate so large DB with falls and data loss. I have found only info that postgres can manipulate DB larger than maximum file size. Thanks for help and sorry for my bad

[ADMIN] Error in pg_dump!

2000-02-21 Thread Trurl McByte
Error in pg_dump! if sequence name like "Order_id_seq" pg_dump generated next code: > SELECT nextval ('Order_id_seq'); It's error! (ERROR: order_id_seq.nextval: sequence does not exist) Need generate some like : SELECT nextval ('"Order_id_seq"'); -- Trurl McByte, Capt. of StasisCruiser

Re: [ADMIN] Backup of db with large objects.

2000-02-21 Thread M . Mazurek
On Mon, 21 Feb 2000, Karel Zak - Zakkr wrote: > > > pg_dump doesn't support large objects, I haven't found any advise how > > > to do it in doc neither in FAQ. How an I to backup a db with large > > > objects without losing my data? > > You need to write a C program using libpq's lo_import and lo_

Re: [ADMIN] Backup of db with large objects.

2000-02-21 Thread Karel Zak - Zakkr
On Sat, 19 Feb 2000, Peter Eisentraut wrote: > On 2000-02-18, [EMAIL PROTECTED] mentioned: > > > pg_dump doesn't support large objects, I haven't found any advise how > > to do it in doc neither in FAQ. How an I to backup a db with large > > objects without losing my data? > > You need to writ