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

Re: Postgresql 8.0.3, symbolic link to /var/lib/pgsql/data/base

From: Chris Travers <chris(at)travelamericas(dot)com>
To: Jeffrey Tenny <jeffrey(dot)tenny(at)comcast(dot)net>,pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgresql 8.0.3, symbolic link to /var/lib/pgsql/data/base
Date: 2005-09-29 01:42:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Jeffrey Tenny wrote:

> Anjan Dave wrote:
>> Why don't you copy/move the entire data directory (minus pg_xlog if 
>> you are separating them)
> I tried that too, and then postmaster wouldn't even start.  I don't 
> remember if it was a permission error or if it was complaining it 
> couldn't find the configuration files.
> I suspect whatever symlink problems are manifesting in just moving 
> 'base' also apply to moving 'data'.

Check the file ownerships.  Maybe a chown -R postgres /home/postgres 
might be in order...

Also, if you are using SE-Linux, this can make things interesting...

Best Wishes,
Chris Travers
Metatron Technology Consulting

> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2005-09-29 02:10:45
Subject: Re: Postgresql 8.0.3, symbolic link to /var/lib/pgsql/data/base
Previous:From: Jeffrey TennyDate: 2005-09-29 01:11:49
Subject: Re: Postgresql 8.0.3, symbolic link to /var/lib/pgsql/data/base

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