Hi,
Only create one user to your aplications and give to her rights to acess your database
You can change the password of postgresql user
In your linux distro type:
su - postgres
psql -U postgres
in the prompt of postgres type:
# alter user postgres with password 'your new password';
After this your password of user postgres are change.
Create an user to your aplications and give this to all users.
Don´t forget of rights (INSERT,SELECT,UPDATE,DELETE) on your tables to this user.
[],s
Marcelo Costa
DBA
Executive Secretary of Education from Pará/Amazônia/Brazil
2006/9/22, Tom Lane <tgl@sss.pgh.pa.us>: "Lane Van Ingen" <lvaningen@esncc.com> writes:
> We created our PostgreSQL instance by compiling it from source, and the
> instance is working just fine. User postgres runs the service; we do not
> know what the password is, and we think it got created automatically by the
> compile / install process.
Are you sure it even *has* a password? In the default RPM installation,
user postgres is created without any password --- the only way to become
postgres is to su there from root, and if you've got root you hardly
need to crack into postgres.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
Marcelo Costa