Firstly, NEVER point log_directory to your cluster data directory -
always keep it separate. (Personally I put all log files under
/var/log/.)
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 sure that the Po
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
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 mi
Στις Δευτέρα 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
>
> Igo
Sir/Madam
I seek help from designers, developers, testers,defect fixers,project
managers or playing any other key role in Free/Open Source software
development or maintenence
in carrying out a study to identify practices and problems of defect
management in various Free/Open Source Software pr
