[ADMIN] How to check running database is 32 bit

Hello, I have installed Postgresql 8.2.4 using Tarball on Suse Linux 10.1 (64 Bit). I already had running Postgresql 64 bit under /var/lib/pgsql. I installed 32 bit 2nd Postgresql using Tarball under /usr/local/pgsql. I want to cross check whether it is 32 bit or 64 bit. So how shld I check the

[ADMIN] DB Performance Tuning

Hello, I am working on database performace tuning on Postgresql 8.1 database build on Suse 10 Linux dedicated server. I am having 32 GB of RAM and 8 CPUs.   I have made minimum recommended settings under postgresql.conf (i.e shared_buffer, work_mem, and effective cache_size also kernel.shmmax

[ADMIN] DB Synchronization.

Hello All, I am having Postgresql 8 installed on 2 RH Linux box. I am keeping one server in stand-by mode. If one server is failed for any reason, the DB should be serving from another server. I am having one question about the synchronization. How to keep another server in updated mode? It s

[ADMIN] SSL Query

Hello   I have configured the postgresql with SSL support enabled. Now from pg_hba.conf file I cofigured some host with SSL support using 'hostssl' and some host with out ssl i.e using 'host'.  How do I come to know that a particular host is connected with SSL support or regularaly connected ? Tha