Re: Installing Postgres

Поиск
Список
Период
Сортировка
От Campbell, Lance
Тема Re: Installing Postgres
Дата
Msg-id B10E6810AC2A2F4EA7550D072CDE8760197D2C@SAB-FENWICK.sab.uiuc.edu
обсуждение исходный текст
Ответ на Re: Installing Postgres  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: Installing Postgres  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-admin
Joshua,
As I stated in my original email I know I can install the database in a
subdirectory of /abc/def/pgsql_data.  I know that.

Let me ask this of the listserv:  Is it possible to install the
PostgreSQL database in a directory and then move the directory later?

Example:  I install PostgreSQL to /abc/data can I move the files then to
/def/data?

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: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: Thursday, August 23, 2007 12:10 PM
To: Campbell, Lance
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Installing Postgres

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Campbell, Lance wrote:
> Command I use to initialize the database with:
>
> /usr/bin/initdb -D /abc/def/pgsql_data
>
> Response:
>
> The files belonging to this database system will be owned by user
> "my_user".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
>
> initdb: directory "/abc/def/pgsql_data" exists but is not empty
> If you want to create a new database system, either remove or empty
> the directory "/abc/def/pgsql_data" or run initdb
> with an argument other than "/abc/def/pgsql_data".
>
>
>
> As I stated in my original email there is a subdirectory in:
> "/abc/def/pgsql_data" called "lost+found".

My solution still applies:

mkdir pgsql_data/pgsql
chown -R postgres.postgres pgsql_data/pgsql
initdb -D pgsql_data/pgsql/data

Sincerely,

Joshua D. Drake


>
> 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: Joshua D. Drake [mailto:jd@commandprompt.com]
> Sent: Thursday, August 23, 2007 11:59 AM
> To: Campbell, Lance
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Installing Postgres
>
> Campbell, Lance wrote:
>> This is not an ownership issue.  It does try to install PostgreSQL.
> It
>> complains because there is a file or directory in the directory where
> I
>> am installing PostgreSQL to.  The same thing will happen if I create
a
>> directory called XYZ and place a file or directory inside of XYZ and
>> then try to install the database.
>
> *sigh*
>
> How about an actual error message and the *exact* command you are
> typing.
>
> Sincerely,
>
> Joshua D. Drake
>
>> 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: Joshua D. Drake [mailto:jd@commandprompt.com]
>> Sent: Thursday, August 23, 2007 11:48 AM
>> To: Campbell, Lance
>> Cc: pgsql-admin@postgresql.org
>> Subject: Re: [ADMIN] Installing Postgres
>
>> Campbell, Lance wrote:
>>> OS: redhat linux
>>> Version of PostgreSQL: 8.2.4
>
>
>>> I had a group that now manages our server set up a
> directory/partition
>>> for us to put postgreSQL into.  The directory is called pgsql_data.
>> The
>>> directory is more than a regular directory.  It contains a
>> subdirectory
>>> called "lost+found".  I would assume this is a logical partition.  I
>>> tried installing postgreSQL directly into this directory but it
> failed
>>> since there is a file in this directory, "lost+found".  Is there a
> way
>>> around this?  Worst case scenario I will create a subdirectory
called
>>> data and put the install in there.  I would have preferred to put it
>> It is probably an ownership issue. If this is linux the mount is
>> probably owned by root. Create a sub directory in pgsql_data that is
>> owned by postgres called pgsql and install it in there.
>
>> Sincerely,
>
>> Joshua D. Drake
>
>>> directly into the pgsql_data.  There would be no other files that
>> would
>>> have gone into the directory/partition other than postgreSQL.  Would
>> it
>>> be possible for me to install postgreSQL into a sub directory of
>>> pgsql_data and then move the files up a directory into pgsql_data?
>
>
>
>
>>> Thanks,
>
>
>>> Lance Campbell
>>> Project Manager/Software Architect
>>> Web Services at Public Affairs
>>> University of Illinois
>>> 217.333.0382
>>> http://webservices.uiuc.edu
>
>
>
>
>
>

- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
            UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGzb9vATb/zqfZUUQRAvBUAJ0afVRD/Tt2vR0LBo6LcQyEvbYKvACgjUns
iL7APXC+v3e6YslHCUbCjak=
=MxlM
-----END PGP SIGNATURE-----

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Installing Postgres
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Installing Postgres