Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with postgresql-9.3
Search options not deleted
user 7119
PostgreSQL version 9.3
1
vote
Accepted
Do PostgreSQL toasted fields use any per row, in-table space?
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 …
- 32.3k
3
votes
Accepted
What does "ERROR: failed to find parent tuple for heap-only tuple at (1192248,5) in table "f...
This error message is new in postgres and is indeed related to the replication bug fixed in 9.3.3
As mentioned in the git commit from Mon, 17 Mar 2014:
The recently-fixed bug in WAL replay could …
- 32.3k
8
votes
Accepted
Missing the pg_ctl package in Postgres 9.3 installation
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
…
- 32.3k
5
votes
Accepted
Store same sequence value in two columns
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 …
- 32.3k
10
votes
Accepted
Adding new null column to table caused lock
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 …
- 32.3k
14
votes
Avoid PG::TRDeadlockDetected
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 …
- 32.3k
1
vote
Accepted
Change posgresql 9.3 slave roll password
the person who set it up left the password the same as the password
for the super user account on our other server
If the other server is the master, it's normal because having different passwo …
- 32.3k
3
votes
changed password for postgres login in pgAdmin, now can't connect to server
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 …
- 32.3k
21
votes
Can IS DISTINCT FROM be combined with ANY or ALL somehow?
Looking at it as a grammar problem, ANY is defined as
(in Row and Array Comparisons):
expression operator ANY (array expression)
But is distinct from is not an operator, it's a "construct" as we …
- 32.3k
2
votes
PostgreSQL bug(?) - logging with a minimum log level
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 …
- 32.3k
10
votes
Accepted
PostgreSQL force sslmode=verify-full
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 …
- 32.3k
8
votes
Accepted
How can I keep a result set without keeping the transaction open?
When a cursor is defined at the SQL level with DECLARE, there is an option WITH HOLD that makes it continue to exist after commiting the current transaction. Quoting the doc:
WITH HOLD specifies t …
- 32.3k
6
votes
Accepted
AWS RDS PostgreSQL dump/restore - syntax error
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 …
- 32.3k
1
vote
Monitoring Amazon RDS with pgtop
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 …
- 32.3k
5
votes
Accepted
dumping database with "compressed data is corrupt" errors
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 …
- 32.3k