Re: [ADMIN] Issues with log-shipping replication

2011-12-15 Thread Rural Hunter
well, is pgsql capable to parse shell variables in postgresql.conf? anway you should check your master log. If it can not archive the wal, there will be errors reported in it. 于2011年12月16日 2:02:03,Khusro Jaleel写到: Hello, I'm trying out a simple example from the Postgresql 9 Administration Cook

[ADMIN] User password encryption using a stronger hashing function?

2011-12-15 Thread Liu, Jianli (Jianli)
By default, postgresql encrypts user passwords using the MD5 hashing function. They can be seen as "md5." in the rolpassword column of the pg_authid table. Is there a mechanism that allows us to change this default behavior such that postgresql can encrypt the passwords stored in the pg_auth

[ADMIN] Issues with log-shipping replication

2011-12-15 Thread Khusro Jaleel
Hello, I'm trying out a simple example from the Postgresql 9 Administration Cookbook about File-based log shipping replication, but I can't get it to work between 2 CentOS 5.7 VMs running Postgresql 9.1. Here are my settings: .bash_profile on master: export PGARCHIVE=/var/lib/pgsql/pgarchive e

Re: [ADMIN] Number of connections still limited on Windows 64-bit?

2011-12-15 Thread lst_hoe02
Zitat von jan-peter.seif...@gmx.de: Hello Andreas, thank you very much for the link. Original-Nachricht Datum: Thu, 08 Dec 2011 13:04:30 +0100 Von: lst_ho...@kwsoft.de Zitat von Jan-Peter Seifert : > I wonder whether the number of connections is still limited on > Windows

[ADMIN] Resuming Incomplete Pg-restore Tasks

2011-12-15 Thread P R
When loading from a custom Pg-dump it'd be helpful to have the option to resume an incomplete or failed attempt. Is there any way to do this now?

[ADMIN] tablespace backup and recovery from or to remote machine

2011-12-15 Thread Karuna Karpe
Hello, I am doing streaming replication in 2 remote machines. On primary server I have two tablespaces. Then I start baseback and copy data directory on primary to standby server I use rsync command. rsync -r /opt/PostgresPlus/9.0/data/ root@192.168.0.115: /opt/PostgresPlus/data_stand