Re: [ADMIN] FAQ Q

2002-06-10 Thread Tom Lane
Tim Ellis <[EMAIL PROTECTED]> writes: > Tom Lane <[EMAIL PROTECTED]> wrote: >> You do not have to trust Postgres itself: in all cases we push the log >> entries out to the OS before declaring a transaction committed. > In all cases while fsync mode is enabled, not in all cases (including > no-fs

Re: [ADMIN] FAQ Q

2002-06-10 Thread Tim Ellis
On Mon, 10 Jun 2002 17:16:23 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > You do not have to trust Postgres itself: in all cases we push the log > entries out to the OS before declaring a transaction committed. In all cases while fsync mode is enabled, not in all cases (including no-fsync) right?

Re: [ADMIN] FAQ Q

2002-06-10 Thread Tom Lane
Tim Ellis <[EMAIL PROTECTED]> writes: > (in summation...) So if data consistency is the most important thing to > me, performance be damned, I still, as of 7.2.1, want to run in fsync > mode? Yup. no-fsync is only suitable if you trust your OS and power supply. You do not have to trust Postgres

[ADMIN] FAQ Q

2002-06-10 Thread Tim Ellis
>From the FAQ: - PostgreSQL runs in two modes. Normal fsync mode flushes every completed transaction to disk, guaranteeing that if the OS crashes or loses power in the next few seconds, all your data is safely stored on disk. In

Fw: [ADMIN] important question

2002-06-10 Thread Vergoz Michael
- Original Message - From: "Vergoz Michael" <[EMAIL PROTECTED]> To: "Tim Ellis" <[EMAIL PROTECTED]> Sent: Monday, June 10, 2002 8:37 PM Subject: Re: [ADMIN] important question > there nothing on this server, no load > > > - Original Message - > From: "Tim Ellis" <[EMAIL PROT

[ADMIN] Fw: important question

2002-06-10 Thread Vergoz Michael
  - Original Message - From: Vergoz Michael To: [EMAIL PROTECTED] Sent: Monday, June 10, 2002 5:53 PM Subject: important question hello,   I'v an : 8 * Pentium !!! XEON 900Mhz 2Mo Level2 16 Go RAM ECC Harddisk ultra-lvd 160 [...]   with linux   Can i support 4096 user in the same t

[ADMIN] important question

2002-06-10 Thread Vergoz Michael
hello,   I'v an : 8 * Pentium !!! XEON 900Mhz 2Mo Level2 16 Go RAM ECC Harddisk ultra-lvd 160 [...]   with linux   Can i support 4096 user in the same time ???     Regards, Vergoz Michael  

Re: [ADMIN] What err ???

2002-06-10 Thread Nick Fankhauser
> Okay. I'll fess up. Ok... it was Friday, I was a little slow. It's Monday now... I'm still a little slow, but I get it now! (chuckle.) In all seriousness, I usually give people the benefit of the doubt on some of the weird questions because we have many users who don't use English as their pri

Re: [ADMIN] What err ???

2002-06-10 Thread Robson Martins
Ok, Nick.Masaru,Joel. Very Thanks! Nick. It helped sufficiently. :-) Brasil vai ganhar a Copa do Mundo! Robson Martins >From Brazil - Original Message - From: "Nick Fankhauser" <[EMAIL PROTECTED]> To: "Robson Martins" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, June 07, 200

Re: [ADMIN] [GENERAL] performance issue using DBI

2002-06-10 Thread Martijn van Oosterhout
On Thu, Jun 06, 2002 at 12:45:09PM -0400, Lee Green wrote: > If you need to get the actual "current value" without incrementing, try: > > SELECT last_value FROM ; > > This will return the last value returned from a nextval command directly > > from the sequence properties in the system tables.

[ADMIN] How restore file system backups?

2002-06-10 Thread Yuen Joyce
Hello, I am interested in the file system level backup: http://www.postgresql.org/idocs/index.php?backup-file.html Is there any documentation/ suggestions on restoring file system backups. Thanks. Joyce Yuen _ ¦b http://explor

[ADMIN] Backups and errors

2002-06-10 Thread Stefano Reksten
Hello list, just a quick question a colleague asked me (and I too am curious): suppose during a pg_dump PostgreSQL finds an error in a table (disk error, file corrupted etc). Where does it blame for the error? Standard output? Log file? Anywhere else? Thanks in advance, Stefano -