Tagged Questions
0
votes
1answer
20 views
Keeping version history of functions in PostgreSQL
For many of my tables, I've added auditing triggers (based on this wiki page). It works very well and has helped me several times figure out who changed what in the system. We have a Python/Django ...
0
votes
0answers
43 views
Waiting for response from Postgres server
I have a problem when query from application (Java) to PostgreSQL.
Here my query list (in 1 session user):
select count (id) from tb_a;
select count (id) from tb_a;
select nextval ('cssq_01');
select ...
1
vote
3answers
44 views
Postgres connection access denied on IPv6 address
Installed PostgreSQL 9.1 x64 on Windows, set up a listen address, but when connecting with pgAdmin I get the following error. Not sure why PostgreSQL is seeing my IPv6 address and not my regular IP ...
0
votes
2answers
45 views
Postgres wont shutdown due to wal archiving
I commanded Postgres to shutdown using the init.d scripts (Linux) over 18h ago.
I can still see the processes running:
-bash-3.2$ ps -fe | grep postg
postgres 2299 3265 0 16:06 pts/5 00:00:00 ...
0
votes
1answer
31 views
PostgreSQL insert into table (not origin) based on a condition on fields on different tables
Lets say you have 4 different tables:
table_1 is a table holding the original data:
table_1
id1 | id2 | score1 | score2 | name_1 | name_2
...
3
votes
1answer
93 views
Algorithm for finding the longest prefix
I have two tables.
First one is a table with prefixes
code name price
343 ek1 10
3435 nt 4
3432 ek2 2
Second is call records with phone numbers
number time
834353212 10
...
3
votes
2answers
61 views
Change built-in default privileges in PostgreSQL?
Introduction.
When I create a database,
postgres=# CREATE DATABASE test2 OWNER test2;
it is created with an empty privileges column:
Name | Owner | Encoding | Collate | Ctype | ...
0
votes
1answer
21 views
Postgres backup and WAL to S3
We are looking for a solution for the following problem:
We have set up streaming replication so we have a master DB and a slave DB, we want to have basebackups and WAL files sent to our S3 storage ...
0
votes
0answers
33 views
How to make continues cluster?
I have a report table with the following index:
providerid, date
The table is around 30M records and it grows about 100K rows per day.
I want to use in the index above as a cluster, but as I ...
3
votes
2answers
166 views
Configuring PostgreSQL for read performance
Our system write a lots of data (kind of Big Data system). The write performance is good enough for our needs but the read performance is really too slow.
The primary key (constraint) structure is ...
1
vote
0answers
29 views
Can't set up witness in Repmgr 2.0
I am trying to setup repmgr using the autofailover quick setup tutorial provided on Github Link
But I am kind of stuck on the witness section, when trying to create the witness with repmgr -d repmgr ...
0
votes
0answers
17 views
Streaming replication in postgresql 9.1 — sender and receiver processes aren't running
I've followed this guide, and cross-referenced the primary postgresql wiki in order to set up replication. I've configured postgresql.conf and pg_hba.conf as directed, and then restarted the master ...
3
votes
0answers
44 views
What happen when Postgresql tablespace is null?
I'm facing a DWH on postgresql with no DBA (I'm not one) so I turn to you with hope to figure this issue/s.
Long story short, when I check the disk usage per tablespace, I get different distribution ...
-2
votes
1answer
87 views
Use select query in stored procedure
I have some questions about stored procedures.
Using select query inside the stored procedure is efficent or using select query in front end. Which is take less time and give the result is fast or if ...
1
vote
1answer
26 views
How to monitor or do vacuum without stop all?
I have postgres9.1
I try to run full vacuum on a specific table , but it run for more than 5 hours.
I stop all process against this table and i cannot have the process down any longer.
Is there a ...
