It's a bad idea to use the 'postgres' user account since this account is the Postgresql *superuser* account. Which means, with this account it is possible to do some serious damage to the system catalogs. You should create a separate Postgres user account and create a database for it.
First switch to the postgres Unix account, enter your current user's password when prompted: $ sudo su -s /bin/bash - postgres Then, when prompted for the password type in the password that you would like to use for this database user: $ createuser -S -D -R -E -P <your database username here> Then: $ createdb -E utf8 -O <your database username here> <your database name> Then edit /etc/postgresql/8.2/main/pg_hba.conf and add the following line: local <your database name> <your database username here> password Save the file, then run: $ pg_ctlcluster 8.2 main reload Log out of the Unix account. On 9/27/07, Bruno Tikami <[EMAIL PROTECTED]> wrote: > or, if you haven't, add the line > > local all postgres password > > be aware that this will allow the user postgres (once password authenticated) > to access all the databases. If you don't want it, change 'all' to you > porject's database name . > > > > On 9/27/07, Kenneth Gonsalves <[EMAIL PROTECTED]> wrote: > > > > > > On 27-Sep-07, at 1:32 PM, Heba Farouk wrote: > > > > > psycopg2.OperationalError: FATAL: Ident authentication failed for > > > user "postgres" > > > > edit your pg_hba.conf file and set authentication to 'password' > > > > -- > > > > regards > > kg > > http://lawgon.livejournal.com > > http://nrcfosshelpline.in/web/ > > > > > > > > > > > > > -- _nimrod_a_abing_ http://abing.gotdns.com/ http://www.preownedcar.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
