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

Hi

2009/10/7 Professor Flávio Brito <prof.flaviobrito@gmail.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@gmail.com>

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice