Re: Problems setting up DB at a different location

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Sven Riedel" <sven(dot)riedel(at)tu-clausthal(dot)de>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Problems setting up DB at a different location
Date: 2001-09-19 02:07:35
Message-ID: NEBBLAAHGLEEPCGOBHDGIEPCDKAA.nickf@ontko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Sven-

I am attaching an html file from our internal company documentation that may
help. We are running PostgreSQL 7.1.3 on Debian. The section in the html
file marked "Some general concepts and experiences we've had:" includes a
description of how we placed data in a separate area. (Most of the links in
this doc won't work because they refer to files that live behind our
firewall.)

One problem that I had was forgetting to use the "-" when doing "su -
postgres". The "-" ensures that you pick up any environment variables
defined in the postgres user's .profile

I hope this helps. I can offer further assistance if it does not.

-Nick

---------------------------------------------------------------------
Nick Fankhauser

nickf(at)doxpop(dot)com Phone 1.765.965.7363 Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/

Attachment Content-Type Size
pgsql_local.html text/html 8.8 KB
pgsql_local.html text/html 8.8 KB

Browse pgsql-admin by date

  From Date Subject
Next Message Oliver Elphick 2001-09-19 04:13:48 Re: Problems setting up DB at a different location
Previous Message Miguel González 2001-09-18 18:02:41 Registring a C function in PostgreSQL