> But afterwards, inside the script, you could use su to temporarily switch to > a less priviledged user: > > ... commands running as root > su postgres -c 'psql ....' # running as postgres > ... running as root again
OK I will try this. I am very confused about something though. Not one person here has said anything about how pg_ident works or what I did wrong. Is pg_ident deprecated? Is there no way to accomplish this with pg_ident? Why has everybody suggested either I don't do what I want/need to do or that I should do it via the su mechanism? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
