Στις Δευτέρα 26 Φεβρουάριος 2007 18:20, ο/η Igor Neyman έγραψε:
And one more question.
Is there a way (function/view) to find machine name on which user
program (connected to Postgres) runs?
You could write a stored procedure
in plsh which simply returns the result of /bin/hostname
Igor
I want to setup a form of replication for postgresql using the warm
standby option
(http://www.postgresql.org/docs/8.2/static/warm-standby.html)
I have had success to let server A to copy the WAL logs to server B (the
standby server). But I have had no success on the recovery side of
things. I
Im back working on PITR with WAL files.
I was busy creating a PITR based file backup procedure
in bash that works just like my boss want it to.
that was complementary to the backup I want to discuss
with you; shouldn't it work? I have repeated this
procedure a few times with the same results, so
Firstly, NEVER point log_directory to your cluster data directory -
always keep it separate. (Personally I put all log files under
/var/log/application_name.)
Secondly, I've copied this to pgsql-admin, not pgsql-interfaces as it's
more of an admin issue than programmability.
You need to make