Re: postgres installation question
On Sat, 2004-05-22 at 22:19, Tom Allison wrote:
> I'm doing a -testing installation of postgresql.
>
> I have the user postgres in the passwd file.
> I don't know what the password is.
>
> I'm wondering:
>
> Should I know it? I can always su posgres from root, but I don't always
> want to have to go root first. Is there is any problems with having a
> real password for login (from say SSH for admin purposes).
It doesn't have a password, unless and until root gives it one.
There is no harm in giving it a password, but the package installation
isn't going to do that, since "su postgres" will do just as well and let
you know which real person is doing things.
In addition, if you create a PostgreSQL user to match your sytem login
and make that user a PostgreQSL administrator (i.e, able to create users
as well as databases) there is almost nothing that you need to log on as
`postgres' to do.
--
Oliver Elphick olly@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"But where shall wisdom be found? And where is the
place of understanding? It cannot be gotten for gold,
neither shall silver be weighed for the price thereof.
Whence then cometh wisdom? and where is the place of
understanding? ...Behold the fear of the Lord, that is
wisdom; and to depart from evil is understanding."
Job 12,15,20,28
Reply to: