The script I used to check the lag time between the primary and the
standby would show that the standby server was not even close, right?
Paula
On Sat, Jun 20, 2015 at 9:51 AM, Jerry Sievers
wrote:
> Adrian Klaver writes:
>
> > On 06/19/2015 01:05 PM, Paula
On Fri, Jun 19, 2015 at 12:01 PM, Adrian Klaver
wrote:
> On 06/18/2015 05:45 PM, Paula Price wrote:
>
>> I have Postgresql 9.2.10 streaming replication set up with log shipping in
>> case the replication falls behind. I discovered that the log-shipping had
>> been disabl
been compromised.
I have run this query to determine the lag time for the standby(in case
this tells me anything):
"SELECT now(), now() - pg_last_xact_replay_timestamp() AS time_lag;
RESULT:
"2015-06-19 00:40:48.83701+00";"00:00:01.078616"
Thank you,
Paula P
iated.
(I have also posted this question to pgsql-admin)
Paula
g i can do to try access my data, im restoring my
last backup, but i want try everything to get the most recent before
give up.
Thanks in advance.
PS: Please, cc me a reply cos im not in the pgsql list.
Samuel Abreu de Paula
sam...@debian-ce.org
Mike Ditka - "If God had wanted man to
close" a table/database/tablespace
and another postgres instance would then "open" it, to support the
migration.
But I didn't find a way to "close" anything without destroying it.
Is there a way to do this using Postgres ?
thanks
Paula
-
open ($database, $oid, \"w\");
echo (\"$handle\\n\");
pg_lowrite ($handle, \"gaga\");
pg_loclose ($handle);
pg_exec ($database, \"commit\");
[script coming from php.net]
Any ideas??
thnx!
/paula
-
n about this kind of subqueries, is
that working fine with Postgresql?
Thanks in advance,
/paula
[EMAIL PROTECTED]
[EMAIL PROTECTED]
:: www.nervemail.net :: free access to POP3 accounts
