From: Medi Montaseri <montaseri@gmail.com>
To: Campbell, Lance <lance@uiuc.edu>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: Installing Postgres
Date: Fri, 24 Aug 2007 11:48:28 -0700
Message-ID: <8078a1730708241148i58ed7dadyd290efec6e0bfec3@mail.gmail.com> (raw)
In-Reply-To: <B10E6810AC2A2F4EA7550D072CDE8760197D32@SAB-FENWICK.sab.uiuc.edu>
References: <B10E6810AC2A2F4EA7550D072CDE8760197D2F@SAB-FENWICK.sab.uiuc.edu>
<10725.1187894512@sss.pgh.pa.us>
<B10E6810AC2A2F4EA7550D072CDE8760197D32@SAB-FENWICK.sab.uiuc.edu>
Just dont get into the habbit of moving db files around like too
much....filesystems will spead your files all over the place and your
database will slow down....
Medi
On 8/23/07, Campbell, Lance <lance@uiuc.edu> wrote:
>
> Tom,
>
>
> It is nice to know that you can actually move the database by simply
> moving the files. That does assume you shut down the database first.
>
> Thanks,
>
> Lance Campbell
> Project Manager/Software Architect
> Web Services at Public Affairs
> University of Illinois
> 217.333.0382
> http://webservices.uiuc.edu
>
>
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Thursday, August 23, 2007 1:42 PM
> To: Campbell, Lance
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Installing Postgres
>
> "Campbell, Lance" <lance@uiuc.edu> writes:
> > The solution, based on emails I have received, is to install
> PostgreSQL
> > into a subdirectory called "data". I then move the contents of "data"
> > back a directory. This way I am able to have the files in the
> directory
> > I want them in. Even though the directory I wanted them in contains a
> > subdirectory. This is how you get around the issue.
>
> NO, NO, NO, NO, NO.
>
> You appear to be impervious to several people telling you this is a
> bad idea, but I will try one more time to explain why. The reason you
> see "lost+found" in that directory is that it is a volume mount point.
> Volume mount point directories should *always* be owned by root, for
> both reliability and security reasons. The setup you are proposing
> would have to have the mount point directory be postgres-owned.
> You will live to regret that if you insist on doing it that way
> (in fact, I'm astonished your sysadmin agreed to it in the first
> place ... he must be pretty new at his job).
>
> Stick with the extra level of directory.
>
> > It appears that
> > the PostgreSQL data directory contents can be moved.
>
> Yeah, they can. The argument here is about exactly where you are
> proposing to move them to. If it were an ordinary directory it'd be
> fine.
>
> regards, tom lane
>
> ---------------------------(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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: montaseri@gmail.com, lance@uiuc.edu, tgl@sss.pgh.pa.us
Subject: Re: Installing Postgres
In-Reply-To: <8078a1730708241148i58ed7dadyd290efec6e0bfec3@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox