How to create a read only user account to access to all pg database?

From: KhunSanAung <khunsanaung(dot)gis(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: How to create a read only user account to access to all pg database?
Date: 2015-11-25 03:35:39
Message-ID: CAAQr1jZihBKxfXk8q=Y60RVqCixdJ2yrp_HLNuja0NKDM_PGLQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

I have several pg database with their own login user account.
For backup purpose, I'd like to create an additional read only user account
that can access all the pg database.
How can I do it?
Via PSQL command or via pgAdmin III client would be okay.

Your help is high appreciated.

Many thanks & best regards

--
Have a nice day!
--

*Mr. Khun San Aung*
* <http://geoportal.icimod.org/>*

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message KhunSanAung 2015-11-25 03:55:23 How to store the PSQL command result into an array or Python dictionary?
Previous Message 'Bruce Momjian' 2015-11-24 21:46:08 Re: Postgresql 9.4 pg_upgrade issues