User Daniel Vérité

301 votes

Accepted

Granting a user account permission to create databases in PostgreSQL

answered Jan 21, 2013 at 21:57

79 votes

Measure the size of a PostgreSQL table row

answered Sep 7, 2012 at 14:23

77 votes

Accepted

Created user can access all databases in PostgreSQL without any grants

answered May 13, 2012 at 9:44

76 votes

Accepted

Why is a new user allowed to create a table?

answered Feb 23, 2013 at 17:50

63 votes

Accepted

Is there a maximum length constraint for a postgres query?

answered Mar 6, 2016 at 16:27

57 votes

Accepted

How to duplicate huge postgres table?

answered Dec 27, 2013 at 13:25

52 votes

Accepted

What is the impact of LC_CTYPE on a PostgreSQL database?

answered Mar 11, 2015 at 14:20

51 votes

Accepted

Preventing PostgreSQL from starting on boot in Ubuntu

answered Dec 31, 2012 at 14:48

49 votes

Accepted

ERROR: no schema has been selected to create in

answered Jul 6, 2015 at 13:44

34 votes

Accepted

pg_restore: [archiver] did not find magic string in file header

answered Aug 22, 2015 at 13:34

33 votes

Accepted

Are regular VACUUM ANALYZE still recommended under 9.1?

answered Jun 1, 2012 at 16:40

32 votes

How to get all roles that a user is a member of (including inherited roles)?

answered Jul 23, 2015 at 0:59

31 votes

Accepted

pg_restore: [archiver (db)] could not execute query: ERROR: schema "public" already exists

answered Jan 27, 2015 at 16:17

28 votes

How do I find out how far along my PostgreSQL query is?

answered Sep 28, 2013 at 14:14

27 votes

Accepted

PostgreSQL, display role members

answered Apr 28, 2016 at 15:34

24 votes

Accepted

Postgres incomplete startup packet error

answered Jan 6, 2015 at 9:09

23 votes

How to verify SSL always being used on Postgresql 9.6

answered Dec 28, 2018 at 13:01

22 votes

Accepted

pgBouncer works great but occasionally becomes unavailable

answered Feb 26, 2014 at 14:25

21 votes

Can IS DISTINCT FROM be combined with ANY or ALL somehow?

answered Mar 6, 2014 at 22:30

20 votes

Accepted

Why "SET LOCAL statement_timeout" does not work as expected with PostgreSQL functions?

answered Nov 19, 2014 at 9:33

20 votes

Accepted

Minimal grants for readonly single-table access on PostgreSQL

answered Apr 27, 2015 at 12:36

20 votes

Accepted

What is retrieved from disk during a query?

answered Jun 6, 2012 at 12:59

19 votes

Postgres Dump To TXT File

answered Aug 29, 2013 at 12:47

19 votes

Postgres RIGHT JOIN with custom array

answered Mar 26, 2013 at 19:35

19 votes

Accepted

How can I return multiple rows of records in PL/pgSQL

answered Sep 18, 2017 at 21:54

18 votes

Setting shared_buffers in postgresql.conf does not seem to take effect

answered Jun 11, 2015 at 10:19

18 votes

Accepted

Postgresql performed a "fast shutdown" by itself. Why? How was it able to do that?

answered Mar 1, 2012 at 0:36

17 votes

Accepted

pg_restore hangs in terminal indefinitely with zero output in verbose mode

answered Jan 10, 2022 at 18:22

16 votes

Accepted

Postgres - Encoding, Collation and CType

answered Jul 6, 2018 at 21:31

16 votes

Accepted

PostgreSQL user can not connect to server after changing password

answered Mar 7, 2013 at 14:42

Stack Exchange Network

479 Answers

Granting a user account permission to create databases in PostgreSQL

Measure the size of a PostgreSQL table row

Created user can access all databases in PostgreSQL without any grants

Why is a new user allowed to create a table?

Is there a maximum length constraint for a postgres query?

How to duplicate huge postgres table?

What is the impact of LC_CTYPE on a PostgreSQL database?

Preventing PostgreSQL from starting on boot in Ubuntu

ERROR: no schema has been selected to create in

pg_restore: [archiver] did not find magic string in file header

Are regular VACUUM ANALYZE still recommended under 9.1?

How to get all roles that a user is a member of (including inherited roles)?

pg_restore: [archiver (db)] could not execute query: ERROR: schema "public" already exists

How do I find out how far along my PostgreSQL query is?

PostgreSQL, display role members

Postgres incomplete startup packet error

How to verify SSL always being used on Postgresql 9.6

pgBouncer works great but occasionally becomes unavailable

Can IS DISTINCT FROM be combined with ANY or ALL somehow?

Why "SET LOCAL statement_timeout" does not work as expected with PostgreSQL functions?

Minimal grants for readonly single-table access on PostgreSQL

What is retrieved from disk during a query?

Postgres Dump To TXT File

Postgres RIGHT JOIN with custom array

How can I return multiple rows of records in PL/pgSQL

Setting shared_buffers in postgresql.conf does not seem to take effect

Postgresql performed a "fast shutdown" by itself. Why? How was it able to do that?

pg_restore hangs in terminal indefinitely with zero output in verbose mode

Postgres - Encoding, Collation and CType

PostgreSQL user can not connect to server after changing password