On Mon, Aug 28, 2023 at 7:34 AM pan snowave <windxp(at)live(dot)cn> wrote:
> But when i connect to psserver by using os user root
> /usr/local/pgsql/bin/psql -p5432 -d db1 -h127.0.0.1
>
If you want to login as the cce role add " -U cce " to your command line
(or one of the various other ways you can specify a db role name via the
cli or libpq)
psql -U cce -h 127.0.0.1 -d db1
Keep in mind you could very well have two lines in your pg_ident.conf file:
test root cce
test root ddf
David J.