Re: 2 questions

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: anj patnaik <patna73(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: 2 questions
Date: 2015-11-28 01:30:38
Message-ID: 565903BE.9090901@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

What is under /opt/nfsDir/Postgres?

>
> 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?

How are you using Postgres now? Please be specific, more detail is
better then less at this point.

>
> 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.

You can Tcl in the database:

http://www.postgresql.org/docs/9.4/interactive/pltcl.html

That will not change things if you let the database throw an exception
there also.

>
> 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?
>
> Thank you!
> ap
>

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-11-28 01:34:15 Re: 2 questions
Previous Message Adrian Klaver 2015-11-28 01:14:53 Re: Problems with pg_upgrade after change of unix user running db.