pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
>

view thread (17+ messages)

Message-ID: <8078a1730708241148i58ed7dadyd290efec6e0bfec3@mail.gmail.com>
Permalink:  ../8078a1730708241148i58ed7dadyd290efec6e0bfec3@mail.gmail.com/
Also on:    postgresql.org/message-id/8078a1730708241148i58ed7dadyd290efec6e0bfec3@mail.gmail.com

 · 

reply

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