[ADMIN] duplicate records after restore

2006-08-27 Thread Gera Mel Handumon
hi,I have 2 pc pc1,pc2. i create a backup from pc1 and restore to pc2. After database restore it will create a duplicate records of my attendance table. i used pgadmin3 1.4.3 for backup/restore. Any help would be greatly appreciated. TIA,Mel

Re: [ADMIN] Advice request: Postgresql setup for flash memories.

2006-08-27 Thread Tom Lane
=?iso-8859-1?q?Enrique=20Ariz=F3n?= <[EMAIL PROTECTED]> writes: > since flash memory hardware is dropping prices at > high rate I was planning to test how Postgresql runs > in such hardware. This is probably a bad idea, unless the number-of-write-cycles limitation of flash memory has gone away wh

[ADMIN] Advice request: Postgresql setup for flash memories.

2006-08-27 Thread Enrique Arizón
Hello, since flash memory hardware is dropping prices at high rate I was planning to test how Postgresql runs in such hardware. For all I have read, main difference between Hard disc storage and flash memory is that of seek time, beeing flash memory card seek time much faster since it lacks mec

Re: [ADMIN] pg_hba changes not honored

2006-08-27 Thread Sriram Dandapani
I suspect the same behavior. Existing jdbc connections are not disconnected..only new ones   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aaron Bono Sent: Sunday, August 27, 2006 11:58 AM To: Tom Lane Cc: Sriram Dandapani; Joshua D. Drake; pgsql-admin@postgresql.

Re: [ADMIN] pg_hba changes not honored

2006-08-27 Thread Aaron Bono
On 8/23/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Sriram Dandapani" <[EMAIL PROTECTED]> writes:> Pg_ctl is pointing to the same directory that postmaster points to on> startup. There is only 1 data directory/postgres installation that I > use.> Pg_ctl informs that postmaster is signaled. When I see