PostgreSQL version 9.0

learn more… | top users | synonyms (1)

0
votes
1answer
108 views

Upgrade PostgreSQL 9.0 to 9.5 in Centos 7 does not work

We have an environment with Postgres 9.0 and centos 6.2 and want to migrate to Postgres 9.5 and Centos 7.2. We installed a new server with Centos 7.2 and Postgres 9.0.23 and restored a database ...
0
votes
0answers
10 views

Security of SQL Trigger Using dynamically stored table name

I'm working with PostgreSQL 9.0 and am learning how to use Triggers to enable some useful functionality. I have an insert trigger on a table that looks like this: feature_id | layer_name| latitude | ...
0
votes
0answers
78 views

Postgres 9.0 recovery from inadvertent drop-all-tables event

Due to a accidental config file check-in, a unit test wiped out our entire production database (did a drop, then re-created the tables). Trying to restore from backup revealed the recent backups were ...