Thread: Regarding Postgres installation and administration on linux suse 9.0
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
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? 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?
Re: Regarding Postgres installation and administration on linux suse 9.0
From
"Frank D. Engel, Jr."
Date:
<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. $