Skip site navigation (1) Skip section navigation (2)

Re: /Var Partition Full - How can a change PGDATA?

From: Luiz Eduardo Cantanhede Neri <lecneri(at)gmail(dot)com>
To: Michael Wood <esiotrot(at)gmail(dot)com>
Cc: Professor Flávio Brito <prof(dot)flaviobrito(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: /Var Partition Full - How can a change PGDATA?
Date: 2009-10-09 10:58:58
Message-ID: 252e1f290910090358u4bcf7fb7rfafa73ed8d4fa60a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi Flávio,

Try to check your bash.rc, pg data my be setting there. If it dont try to
export the new value of pg data from there. When the system reboot try to
echo $PGDATA and check if it has the correct value.


[]'s
Luiz Eduardo Neri

2009/10/9 Michael Wood <esiotrot(at)gmail(dot)com>

> Hi
>
> 2009/10/7 Professor Flávio Brito <prof(dot)flaviobrito(at)gmail(dot)com>:
> > Hi Michael and List
> >
> > I did  ln -sf /sistema/postgresql /var/lib/pgsql ; chown -h
> > postgres.postgres pgsql
> >
> > as you told me, but without success.
>
> Did you get the same error message or a different one?
>
> > In my command list I copied to a right place (my command list omitted it
> )
> > at the second try
> >
> > #cd /var/lib/pgsql
> > #cp -pr data /sistema/postgresql
> >
> > --------------------------------------------------------
> > New PGDATA
> > /sistema/postgresql/data
> >
> > Old PGDATA
> > /var/lib/pgsql (renamed to /var/lib/pgsql_old
> >
> -----------------------------------------------------------------------------------------
> > I created postgresql at  /etc/sysconfig/pgsql/
>
> So it wasn't there previously?
>
> > PGDATA=/sistema/postgresql/data
> > PGPORT=3456
> >
> -----------------------------------------------------------------------------------------
>
> You could try running /etc/init.d/postgresql as follows to see more
> details about what it is doing:
>
> sh -x /etc/init.d/postgresql
>
> Maybe it will help to understand what is going wrong.
>
> --
> Michael Wood <esiotrot(at)gmail(dot)com>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

In response to

pgsql-novice by date

Next:From: Jonathan HardenDate: 2009-10-09 11:56:00
Subject: Functions which use an argument to decide which table to read
Previous:From: Michael WoodDate: 2009-10-09 07:08:31
Subject: Re: /Var Partition Full - How can a change PGDATA?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group