No. Once you've done any transactions in the backup DB, its transaction
history has diverged from the master and you can't resume tracking the
master. It shouldn't even let you try --- what shenanigans did you pull
to force it back into recovery mode?
Well, I didn't think it was shenanigans
David Wall <[EMAIL PROTECTED]> writes:
> Is it allowable to have a backup database in recovery mode, then stop
> recovery (in this case, by putting the trigger file in place to stop
> pg_standby), check out that the backup db appears up to date, stop the
> now active backup db, and then restart
LOG: database system was shut down at 2008-01-11 11:40:05 PST
LOG: starting archive recovery
LOG: restore_command = "~/postgresql/bin/pg_standby -l -d -s 2 -k 20
-t ~/postgresql/restoreWALs/STOP_RESTORE ~/postgresql/restoreWALs %f
%p 2>> ~/pg_standby.log"
*LOG: restored log file "0001
Using PG 8.2, I have a database in recovery mode using pg_standby to
handle the WAL restores.
Is it allowable to have a backup database in recovery mode, then stop
recovery (in this case, by putting the trigger file in place to stop
pg_standby), check out that the backup db appears up to date,
On Fri, 11 Jan 2008, Joshua D. Drake wrote:
Pedro Briones Garc?a wrote:
Hello.
According to PostgreSQL FAQ
*Q: Does PostgreSQL Support 64-bit Computing?*
A: Yes. In fact, we've supported 64-bit systems for at least 10 years, just
like a lot of other Unix and POSIX software. *We do not yet s
On Thu, Jan 10, 2008 at 01:07:09PM +0530, Suresh Gupta VG wrote:
> We are upgrading the pgsql from 7.4.2 to 8.2.5 on Solaris 9 Spark
> machine, I had downloaded the sources also. I had gone through the
> instalation documents too. I could not find the procedure to rollback
> the new version, if the
Selon Daniel Caune <[EMAIL PROTECTED]>:
Hi,
Is there any way to define a SQL stored function that inserts a row in a
table and returns the serial generated?
CREATE TABLE matchmaking_session
(
session_id bigint NOT NULL DEFAULT
nextval('seq_matchmaking_session_id'),
...
);
CREATE FUNCTION
Pedro Briones García wrote:
Hello.
According to PostgreSQL FAQ
*Q: Does PostgreSQL Support 64-bit Computing?*
A: Yes. In fact, we've supported 64-bit systems for at least 10 years,
just like a lot of other Unix and POSIX software. *We do not yet support
64-bit Windows, however*.
Does it
Thanks for the suggestion. I would still like to know whether we have any tools
available in open source domain for the same. Handling views may become
difficult due to size and complexity of the database
- Original Message -
From: Scott Marlowe <[EMAIL PROTECTED]>
Date: Thursday, J
Hello.
According to PostgreSQL FAQ
Q: Does PostgreSQL Support 64-bit Computing?
A: Yes. In fact, we've supported 64-bit systems for at least 10 years, just
like a lot of other Unix and POSIX software. We do not yet support 64-bit
Windows, however.
Does it mean that PostgreSQL can not run on
10 matches
Mail list logo
