Question : For testing purposes I need to get some data from a set of database tables in any arbitrary […]
Tag: postgresql-9.1
Is there some kind of table-level replication in PostgreSQL?
Question : I work with two databases in PostgreSQL 9.1, say A and B, one per application. Database B needs […]
Postgres Streaming Replication: How to re-sync data in master (with standby) after failover
Question : I am absolutely new to postgres 9.1 replication mechanisms. I have managed to set up streaming replication between […]
How do I save functions to individual files in PostgreSQL?
Question : I maintain a legacy application that uses a PostgreSQL database. The application is heavily dependent on stored procedures […]
Is it a good idea to move high-volume and highly-accessed tables to a separate database?
Question : Ours is a web-based application (built on multi-tenant architecture) running PostgreSQL v9.1.3. There are about 450 tables in […]
PostgreSQL: Cannot change directory to /root
Question : I am trying to copy a table planet_osm_polygon from one database osm to another test. I su postgres […]
How to verify that a PostgreSQL base + WAL backup has been restored correctly
Question : Coworkers were trying to extract a PostgreSQL database copy from a backup made at a hot standby in […]
How to monitor or do vacuum without stop all?
Question : I have postgres9.1 I try to run full vacuum on a specific table , but it run for […]
Pass a table array as a parameter to an upsert function in postgresql
Question : i have an UPSERT function which works well but i update and insert records in batches, can this […]
Select a range of integers
Question : I have a ‘range’ of integers (in this case destination ports) that occur: For example: 33848-33254. I want […]