From: Steve Crawford <scrawford@pinpointresearch.com>
To: H. Hall <hhall1001@reedyriver.com>
Cc: pgsql-admin@postgresql.org, Carol Walter <walterc@indiana.edu>
Subject: Re: New postgres installation
Date: Fri, 15 Aug 2008 14:06:40 -0700
Message-ID: <48A5EFE0.7080801@pinpointresearch.com> (raw)
In-Reply-To: <48A5DA84.5020400@reedyriver.com>
References: <78D8C997-9EA7-4D3A-B46A-B135BC633484@indiana.edu>
<48A488AF.9090908@pinpointresearch.com>
<2486959D-BFA3-4832-91CD-645CF09548C0@indiana.edu>
<48A4A1F0.20800@forethought.net>
<5F985D05-4B66-4695-B219-AC43C7C85599@indiana.edu>
<48A5DA84.5020400@reedyriver.com>
H. Hall wrote:
> Carol Walter wrote:
>> It been suggested that I download the binary and just go from there.
>> All the documentation I've read says that for Unix installations
>> should compile source. Would using the binary allow me to do the
>> customization my site requires. I want to put the database in it's
>> original location so that faculty won't have to change they're
>> instructions to students.
>>
>> Carol
> I think that your main question is can you put PG in the directory of
> your choice, if you compile. The answer is yes.
>
What student/faculty documentation includes the data directory location?
I can see that being important for system administration but user access
will be using a client via a local or network port - actual location of
the files won't make any difference. Same with administrative tools like
pg_dumpall. If file location is irrelevant to your users, you are free
to select your installation method regardless of that method's
file-location defaults.
But you do need to be careful about accidentally having mixed versions
of the client tools in different directories so that users could
inadvertently use the old versions of psql, pg_dump, etc.
(I did say "accidentally". If everyone is clued in, you can have
multiple versions of PG running on the same machine. If not, you will be
answering questions due to the unexpected behavior.)
Cheers,
Steve
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: scrawford@pinpointresearch.com, hhall1001@reedyriver.com, walterc@indiana.edu
Subject: Re: New postgres installation
In-Reply-To: <48A5EFE0.7080801@pinpointresearch.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