User Daniel Vérité

1 vote

Accepted

how to operate replicated database properly

answered Mar 7, 2023 at 15:15

0 votes

Why do emails to a user in my database with an alias domain hit the server but get bounced (and the inbox is not created)?

answered Sep 21, 2022 at 9:59

1 vote

Accepted

Why does Postgres tell me "no pg_hba.conf entry for host..." when I have already modified this file?

answered Jul 28, 2022 at 17:52

5 votes

Not able to backup of postgres DB from DBeaver

answered May 19, 2022 at 20:53

0 votes

Accepted

Postgres SELECT extremely slow, EXPLAIN ANALYZE SELECT not slow at all

answered Nov 10, 2020 at 13:11

3 votes

Accepted

How to find the ports of all running PostgreSQL instances (as a non-root user)

answered Jul 16, 2020 at 18:23

0 votes

How can I interact with a new Postgres installation if I can't sudo -u postgres?

answered Jun 21, 2020 at 23:24

7 votes

Accepted

GRANT USAGE ON SCHEMA doesn't do anything

answered Jun 15, 2020 at 20:48

6 votes

Accepted

Postgresql 10 and Ubuntu - Unable to postgresql server UP

answered Mar 9, 2020 at 23:16

0 votes

How to re-create pg_stats_database in Postgres

answered Feb 18, 2020 at 21:18

1 vote

PostgreSQL - Tuning work_mem and max_connections

answered Feb 18, 2020 at 17:15

1 vote

Accepted

How to create database on restore

answered Feb 1, 2020 at 11:50

1 vote

Accepted

pg_dump with -w flag does not read from .pgpass file

answered Oct 15, 2019 at 17:21

2 votes

Accepted

pg_restore without -d switch: what does it do?

answered Oct 8, 2019 at 12:21

2 votes

Accepted

Postgres: pg_dump reports permission denied for large object xxxxx but cannot find it

answered Sep 30, 2019 at 14:27

2 votes

Accepted

What's the most convenient method to ensure that PostgreSQL 9.x hot standy replication is still functioning properly

answered Jan 29, 2013 at 2:04

1 vote

running a second odoo instance on ubuntu gives "Peer authentication failed for user" error in database

answered Jun 28, 2019 at 12:07

1 vote

Set extra_float_digits=3 everywhere in postgres

answered Jun 13, 2019 at 11:42

5 votes

Accepted

What does [unknown]@[unknown] LOG: incomplete startup packet mean?

answered Apr 22, 2019 at 21:10

0 votes

Accepted

Postgresql - Stops listening after mounting volume to data directory

answered Mar 21, 2019 at 16:36

2 votes

Not possible to drop table, not possible to check open connections

answered Jan 17, 2019 at 23:02

3 votes

Accepted

pg_ctl: could not open PID file "/var/lib/postgres/data/postmaster.pid": Permission denied

answered Feb 28, 2018 at 12:17

31 votes

Postgres equivalent to MySQL's \G?

answered Jul 18, 2018 at 13:29

2 votes

Accepted

Copy large CSV (110 mil rows) to Postgres 10 in chucks, resume on failure

answered May 10, 2018 at 18:56

3 votes

Setting postgres logfile's timestamp to same as of local timezone

answered Apr 14, 2018 at 0:26

3 votes

Accepted

PostgreSQL and the Linux Kernel

answered Mar 29, 2018 at 20:38

0 votes

How to create PostgreSQL trigger to insert value for another column?

answered Nov 24, 2017 at 15:29

3 votes

postgresql track counts and autovacuum is not working

answered Jan 23, 2017 at 14:14

13 votes

Accepted

Accessing to a remote PostgreSQL server using port forwarding to another machine

answered Jul 19, 2016 at 20:57

1 vote

PostgreSQL installation under debian

answered Apr 28, 2016 at 15:16

Stack Exchange Network

63 Answers

how to operate replicated database properly

Why do emails to a user in my database with an alias domain hit the server but get bounced (and the inbox is not created)?

Why does Postgres tell me "no pg_hba.conf entry for host..." when I have already modified this file?

Not able to backup of postgres DB from DBeaver

Postgres SELECT extremely slow, EXPLAIN ANALYZE SELECT not slow at all

How to find the ports of all running PostgreSQL instances (as a non-root user)

How can I interact with a new Postgres installation if I can't sudo -u postgres?

GRANT USAGE ON SCHEMA doesn't do anything

Postgresql 10 and Ubuntu - Unable to postgresql server UP

How to re-create pg_stats_database in Postgres

PostgreSQL - Tuning work_mem and max_connections

How to create database on restore

pg_dump with -w flag does not read from .pgpass file

pg_restore without -d switch: what does it do?

Postgres: pg_dump reports permission denied for large object xxxxx but cannot find it

What's the most convenient method to ensure that PostgreSQL 9.x hot standy replication is still functioning properly

running a second odoo instance on ubuntu gives "Peer authentication failed for user" error in database

Set extra_float_digits=3 everywhere in postgres

What does [unknown]@[unknown] LOG: incomplete startup packet mean?

Postgresql - Stops listening after mounting volume to data directory

Not possible to drop table, not possible to check open connections

pg_ctl: could not open PID file "/var/lib/postgres/data/postmaster.pid": Permission denied

Postgres equivalent to MySQL's \G?

Copy large CSV (110 mil rows) to Postgres 10 in chucks, resume on failure

Setting postgres logfile's timestamp to same as of local timezone

PostgreSQL and the Linux Kernel

How to create PostgreSQL trigger to insert value for another column?

postgresql track counts and autovacuum is not working

Accessing to a remote PostgreSQL server using port forwarding to another machine

PostgreSQL installation under debian