martin tan writes:
> I would just want to ask if what is the default password of
> postgresql after installing it... coz when i type su postgres it
> ask me a password which i dont know what?
I'm assuming you're on Linux, and i'm assuming you mean an RPM
installation, and i'm assuming you mean PostgreSQL 7.2.1,... and i'm
assuming you know this isn't a bug (replies to -general list)...
The documentation you installed has the answer, see:
/usr/share/doc/postgresql-7.2.1/README.rpm-dist
The user 'postgres' is created during installation of the server
subpackage. This user by default is UID and GID 26. The user has the
default shell set to bash, and the home directory set to
/var/lib/pgsql. This user also has no default password -- in order to
be able to su to from a non-root account or login as 'postgres' you
will need to set a password using passwd.
To summarise:
su -
passwd postgres
exit
Lee.