Hi,
Finally, I've found two reasons why it didn't work before:
1. after review of the client software, I've found that, sometimes, it
didn't close the connection, and
2. we are not sure that the current value of sequences are flushed in
the logs with the switch_xlog() function.
For 1., the
On Mon, Feb 1, 2010 at 1:30 PM, Muhammad Isnaini moch_isna...@yahoo.com wrote:
# Force to flush current value of sequences to xlog
psql -p $port -t -c 'SELECT datname FROM pg_database WHERE
NOT
datistemplate AND datallowconn' template1|
while read i
do
if [ $i != ];then
psql -p $port
I would like to dump the database through pgpool. I don't find any
reported issue in the mailing list except some in 2004 and 2005. I do
not think there will be a problem, and during my first tests, I don't
notice any problem. But some questions are still there, and could be
interesting for
Hi,
Finally, I've found two reasons why it didn't work before:
1. after review of the client software, I've found that, sometimes, it
didn't close the connection, and
2. we are not sure that the current value of sequences are flushed in
the logs with the switch_xlog() function.
For 1.,