Thread: Regarding Postgres access through C

Dear all

       While trying to connect to postgressql through C program iam
getting the following error .....

                        Connection to database failed.
                        FATAL:  user "root" does not exist

How can I connect to the database as user 'postgres' through C .

Rgds
krishna

am  23.02.2006, um 15:31:22 +0530 mailte Krishnaprasad folgendes:
> Dear all
>
>        While trying to connect to postgressql through C program iam getting
> the following error .....
>                              Connection to database failed.
>                         FATAL:  user "root" does not exist
>
> How can I connect to the database as user 'postgres' through C .


Read:
http://www.postgresql.org/docs/8.1/interactive/ecpg-connect.html

You can find there a example.


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

you have to connect to the database using the operating system's
database user. This is usually "postgres" in most default installs. if
your program is running as root, it will need to specify the user it
wants to use when connecting to the db.

- MrNaz.


Krishnaprasad wrote:
> Dear all
>
>       While trying to connect to postgressql through C program iam
> getting the following error .....
>                             Connection to database failed.
>                        FATAL:  user "root" does not exist
>
> How can I connect to the database as user 'postgres' through C .
>
> Rgds
> krishna
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>

--
--------------------------------------------------------------
MrNaz photo gallery and journal at:
www.mrnaz.com