Re: 2 questions - Mailing list pgsql-general
From | Adrian Klaver |
---|---|
Subject | Re: 2 questions |
Date | |
Msg-id | 565C94DB.7040705@aklaver.com Whole thread Raw |
In response to | 2 questions (anj patnaik <patna73@gmail.com>) |
List | pgsql-general |
On 11/30/2015 09:54 AM, anj patnaik wrote: > 1) directory listing: > > /opt/nfsDir/postgres/9.4/ > /bin > /data > /etc > /pgAdmin3 > .... > > 2) The way I am using PG now is that I have specified the directory > above as the location to install it (from graphical installer). > > Now, it appears that postgres places files in other directories besides > the one specified in the installer. For instance, there are scripts in > /etc/init.d to start the service. Answers without context are not answers. Where is /etc/init.d located, the machine that has the NFS mount or another machine? > > So in answering my own question: it appears PG places files in other > dirs so when I am given a new VM/different physical server with the same > NFS mount I would either need to copy these files over or better yet > un-install the current PG and re-install from scratch. Why not save yourself a lot of trouble, and if it is not the case already, set up Postgres on a central server and connect to it from whatever client you wish. > > Thanks, > ap > > On Fri, Nov 27, 2015 at 8:30 PM, Adrian Klaver > <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote: > > 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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > > -- Adrian Klaver adrian.klaver@aklaver.com
pgsql-general by date: