All Questions
Tagged with postgresql-9.3 postgresql-9.2
14 questions
0
votes
0
answers
54
views
Multiple but not all executions of the same Postgres SELECT query are getting locked endlessly
I am using Postgresql version 9.2.18 on Centos Version CentOS Linux release 7.3.1611 (Core)
In postgres there is a select query on a single table which is getting executed multiple times per minute.
...
- 23
0
votes
1
answer
489
views
Pgpool - 3.5 configuration
[enterprisedb@pgdvdb1dr bin]$ 2017-06-20 11:34:41: pid 103313: WARNING: could not open configuration file: "pgpool.conf"
2017-06-20 11:34:41: pid 103313: DETAIL: using default configuration ...
0
votes
0
answers
56
views
PostgreSQL Query With Sub-Query
On my production server, this query returns no results, so I took it to SQLFiddle to test the results with test data to see if maybe it was a conversion issue. Well SQLFiddle throws an error anytime ...
- 960
-8
votes
2
answers
3k
views
Postgres Dump and Restore on Linux Terminal [closed]
I need to take a dump in postgres db and to be restored on some other server. please tell me the command in Linux with compressed and encrypted format.
- 25
6
votes
1
answer
8k
views
PostgreSQL 9.3 Amazon RDS gives error while using UUID-OSSP extension for generating uuid
I have created DB instance on RDS and used below function. It gave error while with the same PostgreSQL version on a local development machine it works fine.
create or replace function uuid() returns ...
- 161
3
votes
1
answer
2k
views
pg_upgrade and tablespaces (postgres 9.2 to 9.3)
I have a 9.2 installed with tablespaces sitting at:
/var/lib/postgresql/9.2/main
and
/opt/postgres/9.2/second
And unfortunately they are on different filesystems.
This is a Debian package ...
- 145
2
votes
1
answer
3k
views
Postgres Performance Over Group by with MAX and MIN
I just want to retrieve the data for specific location of customers with their ever first and last purchases made in the system.
Table details :
CREATE TABLE customer_location ( id UUID, location_id ...
- 71
2
votes
2
answers
7k
views
Get distinct results based on column and satisfy condition
I have the below select which is selecting from a table with the columns:
id, project_id, keyword_id, position,
Data example:
i, p_id, k_id, p
1, 1, 1, 4
2, 1, 1, 5
3, 1, 1, 6
5, ...
- 683
7
votes
1
answer
8k
views
Upgrading using pg_upgrade on windows fails
When upgrading from postgres 9.2 to 9.3 by following the upgrade procedure found in PostgreSQL 9.3.4 documentation about pg_upgrade, the following command fails:
RUNAS /USER:postgres "CMD.EXE"
After ...
- 251
2
votes
1
answer
2k
views
Migrating Postgres from 9.2 to 9.3
I have 2 CentOS servers, one is running PostgreSQL 9.2 and the other, 9.3.
I'm trying to migrate the database but I'm getting 'relation does not exist' errors.
What I did was on the 9.2 server:
...
- 377
1
vote
1
answer
4k
views
Streaming replication between postgresql 9.2 and 9.3
Does anyone know if it's problematic to have a postgresql 9.3 slave setup to do streaming replication from a postgresql 9.2 master?
- 971
4
votes
1
answer
4k
views
Can't restore my distribution DB postgres 9.2 backup into my staging DB postgres 9.3
I keep getting this pg_restore: [archiver] did not find magic string in file header when i execute a pg_restore -Fc -U "username" -d "dbname" "filename".dmpon my staging DB.
These DB are running on ...
- 143
0
votes
1
answer
1k
views
pg_upgrade 9.2 to 9.3 error
I'm trying to upgrade a PostgreSQL 9.2 database cluster to a 9.3 cluster on a new server.
I've copied the old 9.2 cluster (using rsync) to /srv/data/postgres on the new server and want to convert it ...
- 133
8
votes
3
answers
6k
views
What can I do with the new json field?
PostgreSQL 9.2 introduced the json field type. Why and when should I use it? What benefits does it have over a text field?
I thought there were new query options available, however I haven't seen ...
- 183