Re: Regarding Postgres installation and administration on linux suse 9.0 - Mailing list pgsql-general

From Frank D. Engel, Jr.
Subject Re: Regarding Postgres installation and administration on linux suse 9.0
Date
Msg-id A738DF71-4D1B-11D9-901F-0050E410655F@fjrhome.net
Whole thread Raw
In response to Re: Regarding Postgres installation and administration on linux suse 9.0  (Timothy Perrigo <tperrigo@wernervas.com>)
List pgsql-general
<excerpt>Right, the postgres server will refuse to run if the
controlling user is root.  You need to reconfigure with a different
user account.

</excerpt>

On Dec 11, 2004, at 2:01 PM, Timothy Perrigo wrote:


<excerpt>On Dec 10, 2004, at 4:26 AM, Vikas Kumawat wrote:


<excerpt><fontfamily><param>Arial</param><smaller> </smaller><x-tad-bigger>Dear
Sir /Madam,</x-tad-bigger></fontfamily>


<fontfamily><param>Arial</param><smaller> </smaller><x-tad-bigger>We are
working on Linux suse 9.0 and we have installed Postgres 7.3 through
yast with the privileges of 
"</x-tad-bigger><bold><x-tad-bigger>root</x-tad-bigger></bold><x-tad-bigger>"
user. But we are not able to start / configure the postgres database,
Kindly help us in configuring and starting the same database and how
can we create database and use it. We will be very thankful to you
prompt help.</x-tad-bigger></fontfamily>


<fontfamily><param>Arial</param><x-tad-bigger>Thanks & Regards</x-tad-bigger></fontfamily>

<fontfamily><param>Arial</param><x-tad-bigger>Vikas Kumawat</x-tad-bigger></fontfamily>


</excerpt>

The postgres users should own the data directory, but otherwise should
not have administrative privileges.  What is the specific error you
are getting?




</excerpt>-----------------------------------------------------------

Frank D. Engel, Jr.  <<fde101@fjrhome.net>


$ ln -s /usr/share/kjvbible /usr/manual

$ true | cat /usr/manual | grep "John 3:16"

John 3:16 For God so loved the world, that he gave his only begotten
Son, that whosoever believeth in him should not perish, but have
everlasting life.

$

> Right, the postgres server will refuse to run if the controlling user
> is root.  You need to reconfigure with a different user account.

On Dec 11, 2004, at 2:01 PM, Timothy Perrigo wrote:

> On Dec 10, 2004, at 4:26 AM, Vikas Kumawat wrote:
>
>>  Dear Sir /Madam,
>>
>>  We are working on Linux suse 9.0 and we have installed Postgres 7.3
>> through yast with the privileges of  "root" user. But we are not able
>> to start / configure the postgres database, Kindly help us in
>> configuring and starting the same database and how can we create
>> database and use it. We will be very thankful to you prompt help.
>>
>> Thanks & Regards
>> Vikas Kumawat
>>
>
> The postgres users should own the data directory, but otherwise should
> not have administrative privileges.  What is the specific error you
> are getting?
>
>
>
-----------------------------------------------------------
Frank D. Engel, Jr.  <fde101@fjrhome.net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten
Son, that whosoever believeth in him should not perish, but have
everlasting life.
$

pgsql-general by date:

Previous
From: "Frank D. Engel, Jr."
Date:
Subject: Re: Select after insert to the unique column
Next
From: "Frank D. Engel, Jr."
Date:
Subject: Re: relation "sql_features" does not exist