Database Administrators

Nice Answer

 Nice Answer
Answer score of 10 or more. This badge can be awarded multiple times.

earned this badge 51 times.
ERROR: current transaction is aborted, commands ignored until end of transaction block SQL state: 25P02
Awarded Sep 21 at 11:41
pg_restore hangs in terminal indefinitely with zero output in verbose mode
Awarded Aug 30 at 1:42
PostgreSQL: difference between collations 'C' and 'C.UTF-8'
Awarded May 29 at 4:50
pg_restore ERROR: "Relation does not exist" and creating new database
Awarded May 15 at 23:27
ERROR: could not find array type for datatype information_schema.sql_identifier
Awarded Apr 4 at 18:31
PostgreSQL force sslmode=verify-full
Awarded Jan 16 at 5:34
Does VACUUM FULL need ANALYZE
Awarded Sep 27, 2022 at 9:51
PostgreSQL is running locally but I cannot connect. Why?
Awarded Sep 8, 2022 at 13:31
What is the search_path for a given database and user?
Awarded Jul 26, 2022 at 11:43
PostgreSQL: Change default port used by utilites like psql, createdb, etc
Awarded Jul 6, 2022 at 19:07
Adding new null column to table caused lock
Awarded Dec 3, 2021 at 3:50
What is the difference between xact_start and query_start in postgresql?
Awarded Nov 9, 2021 at 3:37
How do I access Postgres when I get an error about "/var/run/postgresql/.s.PGSQL.5432"?
Awarded Aug 31, 2021 at 14:22
Memory usage on select for large number of rows
Awarded May 15, 2021 at 7:19
Postgres - Encoding, Collation and CType
Awarded Feb 22, 2021 at 8:21
How to verify SSL always being used on Postgresql 9.6
Awarded Jan 14, 2021 at 19:46
Column vs Field: have I been using these terms incorrectly?
Awarded Nov 2, 2020 at 5:40
psql gives Invalid data directory error
Awarded Jun 15, 2020 at 20:52
PostgreSQL Error: out of memory
Awarded May 9, 2020 at 21:50
Postgres RIGHT JOIN with custom array
Awarded Apr 2, 2020 at 8:30
PostgreSQL, display role members
Awarded Mar 4, 2020 at 14:15
Why "SET LOCAL statement_timeout" does not work as expected with PostgreSQL functions?
Awarded Feb 10, 2020 at 15:10
Minimal grants for readonly single-table access on PostgreSQL
Awarded Jan 17, 2020 at 17:35
How can I return multiple rows of records in PL/pgSQL
Awarded Oct 18, 2019 at 2:25
Setting shared_buffers in postgresql.conf does not seem to take effect
Awarded Aug 23, 2019 at 7:25
How to get all roles that a user is a member of (including inherited roles)?
Awarded Mar 27, 2019 at 15:40
Avoid PG::TRDeadlockDetected
Awarded Feb 27, 2019 at 20:10
pg_restore: [archiver (db)] could not execute query: ERROR: schema "public" already exists
Awarded Jun 11, 2018 at 20:28
Difference between fsync and synchronous_commit - postgresql
Awarded May 1, 2018 at 23:05
pg_restore: [archiver] did not find magic string in file header
Awarded Jan 26, 2018 at 14:02
Postgresql performed a "fast shutdown" by itself. Why? How was it able to do that?
Awarded Nov 15, 2017 at 7:46
pgBouncer works great but occasionally becomes unavailable
Awarded Oct 27, 2017 at 11:48
PgBouncer Uncertainties
Awarded Aug 29, 2017 at 16:39
How do I generate a pivoted CROSS JOIN where the resulting table definition is unknown?
Awarded Jul 25, 2017 at 1:41
What is the impact of LC_CTYPE on a PostgreSQL database?
Awarded Jul 12, 2017 at 15:35
Postgres incomplete startup packet error
Awarded Jan 25, 2017 at 14:17
Is there a maximum length constraint for a postgres query?
Awarded Dec 22, 2016 at 20:01
ERROR: no schema has been selected to create in
Awarded May 19, 2016 at 18:43
Measure the size of a PostgreSQL table row
Awarded Mar 15, 2016 at 17:28
How do I find out how far along my PostgreSQL query is?
Awarded Feb 16, 2016 at 6:14
Created user can access all databases in PostgreSQL without any grants
Awarded Sep 7, 2015 at 8:04
How to duplicate huge postgres table?
Awarded May 26, 2015 at 20:09
PostgreSQL PREPARE query with IN () parameters
Awarded Apr 24, 2015 at 15:56
PostgreSQL user can not connect to server after changing password
Awarded Apr 10, 2015 at 20:23
Why is a new user allowed to create a table?
Awarded Mar 6, 2015 at 15:46
Postgres Dump To TXT File
Awarded Dec 27, 2014 at 15:40
Preventing PostgreSQL from starting on boot in Ubuntu
Awarded Nov 13, 2014 at 9:07
Can IS DISTINCT FROM be combined with ANY or ALL somehow?
Awarded Mar 7, 2014 at 19:45
Are regular VACUUM ANALYZE still recommended under 9.1?
Awarded Nov 6, 2013 at 15:52
Granting a user account permission to create databases in PostgreSQL
Awarded Sep 13, 2013 at 0:43
What is retrieved from disk during a query?
Awarded Aug 27, 2012 at 18:44

Others with this badge

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.