Re: 2 questions

On 11/27/2015 01:17 PM, anj patnaik wrote:
> Hello,
> Yes, postgres is currently installed on a nfs mounted file system. So
> when graphical installer runs, there is a form which asks location for
> installation. I specified this path /opt/nfsDir/Postgres where nfsDir is
> a nfs mount. So currently this is where PG 9.4 lives.
>
> My question is when I am given a brand new VM on a different physical
> server, can I mount that same NFS FS and use the Postgres or do I need
> to re-install PG on new VM?
>
> I am not sure if PG writes to any other directories besides the one
> where it is installed.
>
> On the issue of logging, I see a lot of log statements because client
> apps do upserts and since I use Tcl I don't have a SQL proc, but rather
> I let it exception and then do an update on the row.
>
> So, you can limit the size of an individual log, but there is no way to
> tell PG to keep the log file short?
>
> if i choose FATAL, I'd lose some log, right?

Hit Enter to quickly. You answered your own question, it is possible to
have Postgres keep the log file short, just do not log anything:) You
have to decide what is more important the size of the file or the
information in it.

>
> Thank you!
> ap
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com