Search Results

In order to not rely at all on currval, you might transform the INSERT queries in systematic way following this pattern: To insert from a select, instead of : INSERT INTO Test(columns) SELECT colum …

According to a grep in the sources, this error ERROR: compressed data is corrupt happens in case of a decompression failure of a LZ-compressed TOAST'ed value. See http://doxygen.postgresql.org …

Maybe you want to limit the clients to those which present a given certificate, as described in Using client certificates: To require the client to supply a trusted certificate, place certificat …

ALTER TABLE requires an ACCESS EXCLUSIVE lock. From the doc: ALTER TABLE changes the definition of an existing table. There are several subforms described below. Note that the lock level require …

the logger logs every statement Then that behavior comes from log_statement: log_statement (enum) Controls which SQL statements are logged. Valid values are none (off), ddl, mod, and a …

This is a simplified version of Craig Ringer's answer that a non superuser can use directly: SELECT oid, rolname FROM pg_roles WHERE pg_has_role( 'maxwell', oid, 'member'); pg_roles is essentia …

The statistics are produced from the values in the columns. As these values are not changed by VACUUM FULL or even by VACUUM, a fresh ANALYZE is not specifically required. If the database is in a mai …

Adding a new value into a unique index locks out (until commit) any other transaction from inserting the same value. When doing that with multiple values in the same transaction, these locks accumulat …

I don't know if that applies to Amazon RDS, but a possible reason for getting an empty list of queries with pgtop is when using a version older than 3.7.0 (released in August 2013) against a 9.2 or ne …

A pg_dump output with the -Fc (custom) is not a SQL script, it's a compressed archive that only pg_restore is able to handle. You may either pass the dump file to pg_restore and pipe its output to ps …

Yes, see TOAST in Database Physical Storage TOAST usurps two bits of the varlena length word (the high-order bits on big-endian machines, the low-order bits on little-endian machines), thereby …

Let's assume that the target table of the INSERT ("TableD") has a column with a foreign key to "TableC". An INSERT to this table must acquire a shared lock on "TableC" and will keep that lock until th …

In Debian/Ubuntu, the functionalities of pg_ctl are provided by pg_ctlcluster. Quoted from its manpage: NAME pg_ctlcluster - start/stop/restart/reload a PostgreSQL cluster SYNOPSIS …

I think there are two unrelated problems here: 1) failure to connect on Unix domain socket This part of ps output: /opt/PostgreSQL/9.3/bin/postgres -D /home/dev/postgres_data indicates that yo …

The PSQL Console in pgadmin3 consists of opening a terminal and running psql --username yourname [other options] dbname inside it for you, with yourname and dbname being taken from what you've used to …