Enlightened - Badge - Database Administrators Stack Exchange

Enlightened

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

Daniel Vérité

30.4k3 gold badges70 silver badges80 bronze badges

earned this badge 30 times.

ERROR: current transaction is aborted, commands ignored until end of transaction block SQL state: 25P02

Awarded Sep 21 at 11:52

pg_restore hangs in terminal indefinitely with zero output in verbose mode

Awarded Aug 30 at 2:31

pg_restore ERROR: "Relation does not exist" and creating new database

Awarded May 16 at 3:06

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 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