Re: Jehan-Guillaume de Rorthais 2016-09-07 <20160907140816.3e13eaa3@firost>
> Indeed. I never noticed data_directory was set in postgresql.conf file...
>
> But then, why starting PostgreSQL with the following command ?
>
> /usr/lib/postgresql/9.4/bin/postgres -D /var/lib/postgresql/9.4/main \
>
On Sun, 4 Sep 2016 11:40:38 +0200
Christoph Berg wrote:
> Re: Benoit Lobréau 2016-08-31
>
> > Hi,
> >
> > My company is using PGDATA to store configuration files and the guc
> > data_directory to give the path to the instance directory.
> >
> > They would use it like this:
> >
> > pg_ctl star
Re: Benoit Lobréau 2016-08-31
> Hi,
>
> My company is using PGDATA to store configuration files and the guc
> data_directory to give the path to the instance directory.
>
> They would use it like this:
>
> pg_ctl start -D -w
>
> with this directory setup:
>
> /CONFDIR => postgresql.conf pg_
Hi,
My company is using PGDATA to store configuration files and the guc
data_directory to give the path to the instance directory.
They would use it like this:
pg_ctl start -D -w
with this directory setup:
/CONFDIR => postgresql.conf pg_hba.conf pg_ident.conf
/SYSTEM => All the normal stuff i
Adrian Klaver writes:
> On 12/17/2014 05:39 PM, Michael Paquier wrote:
>> PGDATA is not an environment variables that can be used for
>> connections with libpq, see for example fe-connect.c.
> I see. Still it would be nice to have all the environment variables in
> one place.
> Are there any mor
On Thu, Dec 18, 2014 at 12:05 PM, Adrian Klaver
wrote:
> Are there any more then those listed on the libpq page and PGDATA?
>
No other PG* I am aware of.
--
Michael
On 12/17/2014 05:39 PM, Michael Paquier wrote:
On Thu, Dec 18, 2014 at 10:23 AM, Adrian Klaver
wrote:
Just out of curiosity is there a reason PGDATA is not listed with the other
environment variables here?:
http://www.postgresql.org/docs/9.3/interactive/libpq-envars.html
PGDATA is not an envi
On Thu, Dec 18, 2014 at 10:23 AM, Adrian Klaver
wrote:
> Just out of curiosity is there a reason PGDATA is not listed with the other
> environment variables here?:
>
> http://www.postgresql.org/docs/9.3/interactive/libpq-envars.html
PGDATA is not an environment variables that can be used for
conne
Adrian Klaver-4 wrote
> Just out of curiosity is there a reason PGDATA is not listed with the
> other environment variables here?:
>
> http://www.postgresql.org/docs/9.3/interactive/libpq-envars.html
Yes, because PGDATA is not a client concern and thus is not something that
libpq cares about.
C
Just out of curiosity is there a reason PGDATA is not listed with the
other environment variables here?:
http://www.postgresql.org/docs/9.3/interactive/libpq-envars.html
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
On 24 Nov 2006 04:43:02 -0800, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I just can't understand the use of this PGDATA variable!
-I am on FC3. (pgl 7.4)
-I am installing rpms and then running /etc/init.d/postgresql start
(which is done by default)
-The resulting "data" directory is in
On fös, 2006-11-24 at 16:14 -0800, [EMAIL PROTECTED] wrote:
>
> Well.. you are correct!
> After studying the contents of "/etc/init.d/postfresql", I put
> "PGDATA=/home3/mylargedisk/data" in "/etc/sysconfig/pgsql/postgresql"
> and it now works.
>
> So what the . is this PGDATA!! It must b
Well.. you are correct!
After studying the contents of "/etc/init.d/postfresql", I put
"PGDATA=/home3/mylargedisk/data" in "/etc/sysconfig/pgsql/postgresql"
and it now works.
So what the . is this PGDATA!! It must be a trivial concept
cause nobody else is worried about how it works!! An
> I just can't understand the use of this PGDATA variable!
>
> -I am on FC3. (pgl 7.4)
> -I am installing rpms and then running /etc/init.d/postgresql start
> (which is done by default)
> -The resulting "data" directory is in /var/lib/pgsql/data
>
> I now want the "data" directory to be on
>
I just can't understand the use of this PGDATA variable!
-I am on FC3. (pgl 7.4)
-I am installing rpms and then running /etc/init.d/postgresql start
(which is done by default)
-The resulting "data" directory is in /var/lib/pgsql/data
I now want the "data" directory to be on
/home3/myreallyl
Should be selv explainable:
postgres@Server:/home/legshot > initdb
initdb: You must identify where the the data for this database
system will reside. Do this with either a --pgdata invocation
option or a PGDATA environment variable.
postgres@Server:/home/legshot > echo $PGDATA
/mnt/hdb/usr/loca
16 matches
Mail list logo
