[GENERAL] Server memory and efficientcy

2007-03-25 Thread amrit angsusingh
# - Connection Settings - #listen_addresses = 'localhost' # what IP address(es) to listen on; listen_addresses = '*' # comma-separated list of addresses; # defaults to 'localhost', '*' = all #port = 5432 max_connections = 200 # note: increasing max_connections costs ~400 bytes of shared memo

[GENERAL] Howto optimize pg 8.1.4 and FC6 x64 ??

2007-03-23 Thread amrit angsusingh
= 212 1. How should I adjust my new configuration to improve the performance ? 2. And should I set autovaccum = on and if it is on what is the other proper parameter to be set? Thank a lot for your help. -- Amrit Angsusingh Thailand

[GENERAL] DBmirror

2006-12-21 Thread amrit
install Pg-perl source after standard rpm process? Anybody use postgresql with rpm and DBmirror? Amrit Thailand ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] Cannot connect Postgresql 8.1 64 bit

2006-04-08 Thread amrit
of module configuration. What should I set in postgresql.conf to be able to connect to my postgres server? Thanks. Amrit Thailand ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if yo

Re: [GENERAL] Could DBmirror be done with the mechine using RPM installation instaed of souce code [tar.gz] ?

2006-02-25 Thread Amrit Angsusing
I try to do it by rpm installation but the seemed to miss some file which was described by the doc. for ex. pending.so and its' path and perl /./DBmirror.pl could not run Could you suggest me the URL how to install DBmirror by the rpm mechine? Thanks Amrit  2006/2/25, chris smith &l

[GENERAL] Could DBmirror be done with the mechine using RPM installation instaed of souce code [tar.gz] ?

2006-02-24 Thread Amrit Angsusing
I use the two  mechines with FC3 and postgresql 8.1 RPM installation and would like to do DBmirror or other postgresql database replication from master to slave server . Could I do this replication using RPM or I must use the tar.gz version ? Could anybody suggest me about replication? Amrit