User pifor

4 votes

Accepted

Uniquely Append to Array on Conflict PostgreSQL

answered Mar 13, 2020 at 16:39

4 votes

Accepted

Postgres functions: how to pass a type as an argument

answered Mar 31, 2020 at 11:06

4 votes

How to estimate the size of a PostgreSQL DB to be dumped through pg_dump

answered Apr 6, 2020 at 16:33

4 votes

Is my database secure? / What does "=Tc/postgres" allow?

answered Apr 6, 2020 at 18:25

4 votes

Accepted

Postgresql - how to do backup/restore on a database level?

answered Apr 8, 2020 at 7:43

4 votes

Accepted

Differences between .out and .sql in pg_dump PostgreSQL

answered Apr 8, 2020 at 17:12

3 votes

Accepted

MySQL restore dump takes too long to complete, how DBAs deal/replicate large databases?

answered Apr 3, 2020 at 10:59

2 votes

Any possible way to get a progress estimate for ALTER COLUMN TYPE in Postgres?

answered Apr 9, 2020 at 6:04

2 votes

How do I check if PostGIS is installed in my PostgreSQL?

answered Apr 18, 2020 at 7:06

2 votes

Accepted

ORA-01658: unable to create INITIAL extent for segment in tablespace SYSAUX; JOB_SCHEDULER is biggest occupant

answered May 9, 2020 at 17:16

2 votes

Oracle 19c database instance doesn't register with listener

answered Jun 17, 2020 at 20:46

2 votes

Adding multiple files to a tablespace

answered Jul 3, 2020 at 7:12

2 votes

Oracle Delete From a View

answered Apr 29, 2020 at 15:29

2 votes

Accepted

Foreign key references on column definitions are ignored. Feature, not a bug — why?

answered Apr 2, 2020 at 7:00

2 votes

Finding cause of high write IOPS on RDS Postgesql

answered Mar 3, 2020 at 15:58

2 votes

Tracing oracle database

answered Mar 13, 2020 at 15:10

1 vote

How to determine if Oracle Java classes are being used

answered Mar 13, 2020 at 16:09

1 vote

Investigating an Oracle 12c outage after the fact, while limited to SQL*Plus

answered Mar 2, 2020 at 17:09

1 vote

Accepted

Postgresql role_table_grants grantee differences between users

answered Mar 6, 2020 at 12:24

1 vote

Accepted

With Postgresql v10 and WAL2JSON... Is it possible to include the database name / datname in the json?

answered Mar 7, 2020 at 8:42

1 vote

Accepted

MariaDB: Connecting from LAN on Centos

answered Mar 9, 2020 at 16:21

1 vote

When do I need to DEALLOCATE a prepared statement in a MySQL stored procedure?

answered Mar 3, 2020 at 16:30

1 vote

PostgreSQL failover: Who is responsible for handling it? How do clients connect to the new leader?

answered Mar 3, 2020 at 17:44

1 vote

PostgreSQL 9.6.12 autovacuum constantly running on system tables

answered Mar 4, 2020 at 8:30

1 vote

Accepted

How to install Barman with pg_receivewal and pg_basebackup without install PostgreSQL server?

answered Mar 6, 2020 at 8:39

1 vote

Accepted

What are v$database, SID, ServiceName, istance in Oracle 18c?

answered Mar 29, 2020 at 8:29

1 vote

Accepted

postgres ip address on auth logs

answered Mar 30, 2020 at 9:54

1 vote

Accepted

Tracing oracle database

answered Mar 13, 2020 at 19:43

1 vote

Accepted

Where to find Dummy Data For Oracle Database

answered Mar 19, 2020 at 11:04

1 vote

Why can't I create a MySQL user even if i have 'all priviliges'?

answered Mar 19, 2020 at 17:09

Stack Exchange Network

63 Answers

Uniquely Append to Array on Conflict PostgreSQL

Postgres functions: how to pass a type as an argument

How to estimate the size of a PostgreSQL DB to be dumped through pg_dump

Is my database secure? / What does "=Tc/postgres" allow?

Postgresql - how to do backup/restore on a database level?

Differences between .out and .sql in pg_dump PostgreSQL

MySQL restore dump takes too long to complete, how DBAs deal/replicate large databases?

Any possible way to get a progress estimate for ALTER COLUMN TYPE in Postgres?

How do I check if PostGIS is installed in my PostgreSQL?

ORA-01658: unable to create INITIAL extent for segment in tablespace SYSAUX; JOB_SCHEDULER is biggest occupant

Oracle 19c database instance doesn't register with listener

Adding multiple files to a tablespace

Oracle Delete From a View

Foreign key references on column definitions are ignored. Feature, not a bug — why?

Finding cause of high write IOPS on RDS Postgesql

Tracing oracle database

How to determine if Oracle Java classes are being used

Investigating an Oracle 12c outage after the fact, while limited to SQL*Plus

Postgresql role_table_grants grantee differences between users

With Postgresql v10 and WAL2JSON... Is it possible to include the database name / datname in the json?

MariaDB: Connecting from LAN on Centos

When do I need to DEALLOCATE a prepared statement in a MySQL stored procedure?

PostgreSQL failover: Who is responsible for handling it? How do clients connect to the new leader?

PostgreSQL 9.6.12 autovacuum constantly running on system tables

How to install Barman with pg_receivewal and pg_basebackup without install PostgreSQL server?

What are v$database, SID, ServiceName, istance in Oracle 18c?

postgres ip address on auth logs

Tracing oracle database

Where to find Dummy Data For Oracle Database

Why can't I create a MySQL user even if i have 'all priviliges'?