Skip to main content
Database Administrators

Enlightened

 Enlightened
First to answer and accepted with score of 10 or more. This badge can be awarded multiple times.

earned this badge 33 times.
Avoid output disappearing in psql
Awarded May 29 at 15:52
What does PostgreSQL Status active (exited) mean?
Awarded May 14 at 13:05
Why isn't to_char IMMUTABLE, and how can I work around it?
Awarded May 2 at 2:41
ERROR: current transaction is aborted, commands ignored until end of transaction block SQL state: 25P02
Awarded Sep 21, 2023 at 11:52
pg_restore hangs in terminal indefinitely with zero output in verbose mode
Awarded Aug 30, 2023 at 2:31
pg_restore ERROR: "Relation does not exist" and creating new database
Awarded May 16, 2023 at 3:06
ERROR: could not find array type for datatype information_schema.sql_identifier
Awarded Apr 4, 2023 at 18:31
PostgreSQL force sslmode=verify-full
Awarded Jan 16, 2023 at 7:03
Does VACUUM FULL need ANALYZE
Awarded Sep 27, 2022 at 11:55
PostgreSQL: Change default port used by utilites like psql, createdb, etc
Awarded Jul 7, 2022 at 0:26
Adding new null column to table caused lock
Awarded Dec 3, 2021 at 3:56
What is the difference between xact_start and query_start in postgresql?
Awarded Nov 9, 2021 at 3:46
Memory usage on select for large number of rows
Awarded May 15, 2021 at 9:20
Postgres - Encoding, Collation and CType
Awarded Feb 22, 2021 at 8:26
psql gives Invalid data directory error
Awarded Jun 15, 2020 at 21:06
PostgreSQL, display role members
Awarded Mar 4, 2020 at 15:15
Why "SET LOCAL statement_timeout" does not work as expected with PostgreSQL functions?
Awarded Feb 10, 2020 at 16:15
Minimal grants for readonly single-table access on PostgreSQL
Awarded Jan 17, 2020 at 18:25
How can I return multiple rows of records in PL/pgSQL
Awarded Oct 18, 2019 at 3:00
pg_restore: [archiver (db)] could not execute query: ERROR: schema "public" already exists
Awarded Jun 11, 2018 at 20:54
Difference between fsync and synchronous_commit - postgresql
Awarded May 1, 2018 at 23:59
pg_restore: [archiver] did not find magic string in file header
Awarded Jan 26, 2018 at 14:07
Postgresql performed a "fast shutdown" by itself. Why? How was it able to do that?
Awarded Nov 15, 2017 at 10:28
pgBouncer works great but occasionally becomes unavailable
Awarded Oct 27, 2017 at 12:19
What is the impact of LC_CTYPE on a PostgreSQL database?
Awarded Jul 12, 2017 at 15:45
Postgres incomplete startup packet error
Awarded Jan 25, 2017 at 14:22
Is there a maximum length constraint for a postgres query?
Awarded Dec 22, 2016 at 21:07
ERROR: no schema has been selected to create in
Awarded May 19, 2016 at 19:18
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:14
PostgreSQL PREPARE query with IN () parameters
Awarded Apr 24, 2015 at 16:27
Why is a new user allowed to create a table?
Awarded Mar 6, 2015 at 15:56
Granting a user account permission to create databases in PostgreSQL
Awarded Sep 13, 2013 at 1:08

Others with this badge