Hey All,
Last year with the revisions to CREATEROLE I decided that having a view
that allowed one to more readily see the membership graph of their cluster
would be useful. I originally tried to write something up for psql but
decided that was impractical given its requirements. Therefore, I put
On 4/5/24 02:39, Adnan Dautovic wrote:
Dear Adrian,
Adrian Klaver wrote:
Define 'read-only', especially as it applies to the privileges on the
public schema.
I am not quite sure which information you are looking for
exactly. According to this [1], I ran the following query:
WITH "names"("na
Adnan Dautovic writes:
> However, this lead me to [2] and I find the output very
> interesting:
> SELECT * FROM pg_timezone_names ORDER BY name;
>> "name" "abbrev""utc_offset""is_dst"
>> "Turkey" "+03" "03:00:00" false
>> "UCT""UCT" "00:00:00" false
>>
Dear Adrian,
Adrian Klaver wrote:
Define 'read-only', especially as it applies to the privileges on the
public schema.
I am not quite sure which information you are looking for
exactly. According to this [1], I ran the following query:
WITH "names"("name") AS (
SELECT n.nspname AS "name"
Hi Tom,
thank you for your reply!
Tom Lane wrote:
You realize of course that PG 9.4.x is four years past EOL, and that
the last release in that series was 9.4.26, so that your remote is
missing three or so years' worth of bug fixes even before its EOL.
The underlying macOS platform looks a bit
> On 5 Apr 2024, at 06:47, Rama Krishnan wrote:
> Could you please explain me how does pg_upgrade works one of my friends it
> works based on pg_restore I am bit confused
The documentation does a fairly good job explaining how it works, and there are
multiple blogposts and presentations on the
Hi Team,
Could you please explain me how does pg_upgrade works one of my friends it
works based on pg_restore I am bit confused