[ADMIN] constraints primary key and foreign key lost.

2012-02-22 Thread Gera Mel Handumon
Good Day! constraints primary key and foreign key lost. The backup and restore procedure on the same server 64bit postgresql 9.1.2 running on Windows 2008. No error during backup and restore. What Happen? TIA - Share your

[ADMIN] PgAdmin3 for PostgreSQL 9 Linux version

2010-11-25 Thread Gera Mel Handumon
Hello, What version of pgadmin3 to be used for postgresql 9 running on CentOS 5? I encountered some errors when i used the pgadmin3 1.8.4. I've search for newer version of pgadmin3 for Linux but no luck at all. TIA for you valuable help. -- Geramel

Re: [ADMIN] PgAdmin3 for PostgreSQL 9 Linux version

2010-11-25 Thread Gera Mel Handumon
Where can i find the 1.12 RPM release of PgAdmin3? It's 1.8 available for RPM. TIA. On Thu, Nov 25, 2010 at 2:08 AM, Guillaume Lelarge guilla...@lelarge.info wrote: Le 25/11/2010 11:02, Gera Mel Handumon a écrit : Hello, What version of pgadmin3 to be used for postgresql 9 running on CentOS

[ADMIN] pg DATA folder restoration

2009-12-07 Thread Gera Mel Handumon
Hello, My pc crash, all i can do is get the DATA folder of postgresql. What is the proper restoration procedure of DATA folder to newly installed postgresql server (MSwindows). TIA -- Gera Mel E. Handumon - Share your knowledge.

[ADMIN] Restoring database from Tablespace

2007-04-25 Thread Gera Mel Handumon
Hi! My XP was corrupted. I can no longer run the pgdump. The tablespace is in other drive. Is it possible to restore the database using only the data in my tablespace? What's the work-around in this problem? thanks in advance... Mel ---(end of

[ADMIN] duplicate records after restore

2006-08-28 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