PostgreSQL is a powerful, enterprise class, open source RDBMS. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability and data integrity. It runs on all major operating systems, including Linux, UNIX and Windows. It prides ...
0
votes
1answer
16 views
PostgreSQL problems on Ubuntu 12.04
I'm having terrible problems with PostgreSQL initialization on my VPS. I followed several tutorials on this topic and nothing made my database server work.
I followed these steps:
sudo apt-get ...
2
votes
1answer
19 views
redundant foreign keys in PostgreSQL - are there any indexing benefits?
Note: this is not the same as this SO question which is about adding redundant information in the tables themselves.
Does the final statement in the below series of statements buy me anything in ...
2
votes
1answer
49 views
Enforcing constraints “two tables away”
I ran into some trouble modeling an electrical schematic in SQL.
The structure I'd like to capture is
part ←────────── pin
↑ ↑
part_inst ←───── pin_inst
where "inst" is short ...
0
votes
2answers
26 views
Configure postgresql recovery again to be slave
I completed a replication setup using PostgreSQL. Everything was working fine, so I proceeded doing a test by bringing down the main database and promoting the slave to be new master (via touch ...
3
votes
0answers
21 views
User locking tables without privileges
This is a restatement of a question asked on the GIS Stack Exchange here. Although it has GIS-specific elements it may be be a more general PostgreSQL effect.
I have a PostgreSQL 8.4.4 database ...
0
votes
1answer
39 views
Circular foreign key deferrable cascade behavior
I am trying to determine what happens for a particular circular foreign key that will cascade delete. Please feel free to address any other possibilities that my inexperience has not listed.
On my ...
1
vote
1answer
58 views
Restore postgres data/tablespace to new tablespace (at new mount point)?
I have a bunch of test/development databases which we currently refresh with production data as-needed using a NetApp filer's snapshot capabilities - we have a production slave with its datadir on a ...
1
vote
0answers
30 views
MATCH FULL vs MATCH SIMPLE
I've noticed a MATCH SIMPLE or MATCH FULL option in phpPgAdmin, but I can't find a description in the docs.
How do they function?
The default is set to MATCH SIMPLE.
0
votes
1answer
13 views
Postgres replication: Do I need to rsync pg_xlog files if I have archiving setup in master?
I am trying to replicate a master to slave, without shutting down my master.
In the tutorial here: http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial, they recommend these steps:
...
0
votes
0answers
18 views
PostGres- How to loop in Table to update every record in Table
I am working on complicated problem, but I will simplify it to this problem.
I have two tables
A [ID, column1, column2, column3]
B [ID, column1, column2, column3, column4]
and i want to update the ...
0
votes
0answers
15 views
PgPool 2 with HA Proxy
So, I'm looking to add high availability to a postgresql server. I've looked into some tutorials on the web but, haven't been able to find exactly what I'm looking for.
E.g.:
PostgreSQL ...
1
vote
0answers
62 views
Postgres database zero down time production deployment
I need some idea about how I can deploy a financial application in production environment using PostgreSQL DB with zero down time. I have two servers in Master-Slave design. Currently I am giving ...
1
vote
1answer
40 views
How do I access a old saved tablespace after reinstalling postgres?
So a lot of things might have gone wrong here. I first installed postgres 9.3 on mac 9.1 via homebrew to manage some data. I am using postgres.app. Turns out my harddrive was too small so I decided to ...
0
votes
1answer
18 views
Multiple source CASCADE DELETE behavior
I'm having trouble understanding Postgres's CASCADE DELETE behavior.
If table_A REFERENCES table_B, and the column referenced could have multiple instances of the same value, will the table_A row be ...
0
votes
1answer
57 views
create a batch script on windows that periodically starts a sql function
I need to create a batch script on windows that periodically starts a sql function written in 'plpgsql'.
I can use windows schedule task for creating a cron job but I don't know how to write the ...
