Is it possible to have multiple host destinations in the archive_command
parameter of postgresql.conf to be able to mantain 2 standby datbase
with write ahead log???
Can we use something like:
archive_command = '/usr/bin/scp -Cv %p
host_standby1:/var/lib/pgsql/archivelog/%f /usr/bin/scp -Cv
Am Dienstag 31 August 2010 11:36:31 schrieb Silvio Brandani:
Is it possible to have multiple host destinations in the archive_command
parameter of postgresql.conf to be able to mantain 2 standby datbase
with write ahead log???
You have to write a shell script and run this as archive command.
Probably questions best asked on hackers but I figure many are represented here.
Will there ever be a release where a dump-restore is not necessary?
Perhaps, at least, minor releases (e.g. 9.0 to 9.1) will not require a
dump-restore?
From 9.0 Release Notes:
E.1.2. Migration to Version 9.0
A
Excerpts from Greg Spiegelberg's message of mar ago 31 09:04:18 -0400 2010:
Probably questions best asked on hackers but I figure many are represented
here.
Will there ever be a release where a dump-restore is not necessary?
Perhaps, at least, minor releases (e.g. 9.0 to 9.1) will not require
On Tue, Aug 31, 2010 at 9:07 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Greg Spiegelberg's message of mar ago 31 09:04:18 -0400 2010:
Probably questions best asked on hackers but I figure many are represented
here.
Will there ever be a release where a dump-restore is
On Tue, Aug 31, 2010 at 9:33 AM, Greg Spiegelberg
gspiegelb...@gmail.com wrote:
On Tue, Aug 31, 2010 at 9:07 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Greg Spiegelberg's message of mar ago 31 09:04:18 -0400 2010:
Probably questions best asked on hackers but I figure
Kevin Grittner wrote:
*ukasz Brodziaklukasz.brodz...@hotmail.com wrote:
From: kevin.gritt...@wicourts.gov
Are you looking for statistics or the actual prior versions of
rows?
I'm looking for actual versions of row data. What I want to
achieve as a final result is a kind of data
On Tue, 2010-08-31 at 09:42 -0600, Scott Marlowe wrote:
All I'm suggesting is lumping those things requiring a dump/restore
together for major updates.
That's exactly what does happen, if you remember that pgsql is
numbered major.major.minor.
Perhaps thinking about it like this will
time echo '\timing \\select * from table1 where id = 123;' | psql
I am trying to time a simple select statement from different clients located at
different places. The database is on US east-coast.
In the above query. the 'timing' will time the database time and the 'time'
command at the very
A J s5...@yahoo.com wrote:
time echo '\timing \\select * from table1 where id = 123;' | psql
In the above query. the 'timing' will time the database time and
the 'time' command at the very start will time the complete time
for the query including network time.
No, the 'timing' will say
OK, thanks Kevin. So to measure just the time take by database server, I guess
I
need to set the log_min_duration_statement and log_statement parameters in
postgresql.conf
log_min_duration_statement output should stay constant for all the different
clients across different geographic
A J s5...@yahoo.com wrote:
log_min_duration_statement output should stay constant for all the
different clients across different geographic locations.
I'm not sure timings there will be totally immune to network speed.
The whole execution engine is designed around the top level pulling
rows
Hello,
The question is maybe stupid but it's a trouble to me. I would like to perform
some tasks on my linux (ubuntu) using db from work unfortunatly the DB has
WIN1250 encoding and the PostgreSQL in linux has UTF-8 is it possible to
somehow change the server's locale as I may not change the
*ukasz Brodziaklukasz.brodz...@hotmail.com wrote:
I would like to perform some tasks on my linux (ubuntu) using db
from work unfortunatly the DB has WIN1250 encoding and the
PostgreSQL in linux has UTF-8 is it possible to somehow change the
server's locale as I may not change the encoding of
The version in 8.4. I'm trying to copy the database from Windows to Linux. If
it is of any importance the version of Windows Postgres is 8.2
Date: Tue, 31 Aug 2010 14:37:19 -0500
From: kevin.gritt...@wicourts.gov
To: lukasz.brodz...@hotmail.com; pgsql-admin@postgresql.org
Subject: Re:
On Tue, Aug 31, 2010 at 1:01 PM, A J s5...@yahoo.com wrote:
OK, thanks Kevin. So to measure just the time take by database server, I
guess I need to set the log_min_duration_statement and log_statement
parameters in postgresql.conf
log_min_duration_statement output should stay constant for all
*ukasz Brodziaklukasz.brodz...@hotmail.com wrote:
The version in 8.4. I'm trying to copy the database from Windows
to Linux. If it is of any importance the version of Windows
Postgres is 8.2
Use pg_dump from your 8.4 machine. I would use the --encoding
switch when I ran pg_dump to get
17 matches
Mail list logo