What is the most effective method for
syncronizing a database from a main to a backup machine? I am now
running 8.0. Is it necessary to drop the database from the secondary
machine and restore it from a dump of the primary?
Michael Fuhr <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/04/2005 05:30 PM
To
Lowell Hought/AGL/[EMAIL PROTECTED]
cc
pgsql-general@postgresql.org
Subject
Re: [GENERAL] DNS vs /etc/hosts
On Thu, Aug 04, 2005 at 04:01:43PM -0500, [EMAIL PROTECTED]
wrote:
> I also pe
How might I check for that? And
if it is determined to be a problem, how would I remove the guilty modules?
Thomas Pundt <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/05/2005 07:19 AM
To
pgsql-general@postgresql.org
cc
Lowell Hought/AGL/[EMAIL PROTECTED]
Subject
Re: [G
Your assessment is correct ... the
same version of
psql behaves the same on different machines, and different
versions of psql behave differently on the same machine.
The difference must have to do with
the functions that differ in the different versions of psql. In looking
through the code for
Both dig and nslookup are fast on all
machines. 'psql' is fast on all machines, as long as I am using the
version compiled with version 7.2. It is only 'psql' compiled with
version 8.0 that is slow. I don't think DNS is the problem, but rather
the way psql in version 8.0 attempts to get the DNS
04/2005 10:56 AM
To
Lowell Hought/AGL/[EMAIL PROTECTED]
cc
pgsql-general@postgresql.org
Subject
Re: [GENERAL] DNS vs /etc/hosts
Am Donnerstag, den 04.08.2005, 10:13 -0500 schrieb
[EMAIL PROTECTED]:
>
> I am changing from 7.2 to 8.0 and have both installed now on various
> Li
I am changing from 7.2 to 8.0 and have
both installed now on various Linux machines. When I use the psql
command line interface with a -h hostname, the connection time from 7.2
is instant while the connection time from 8.0 is 15 seconds. My assumption
is that 7.2 checks the /etc/hosts file first
