Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
postgres 9.0 streaming replication for reporting
Hello, I'm designing a plan to upgrade from postgres 8.4. Our current setup includes three servers/dbs: 1. Production 2. Warm Standby (WAL shipping) 3. Reporting (built by ETL jobs) I was hoping to have a similar setup with 9.0, but have the Reporting db maintained by replication instead of...- LD50
- Thread
- Replies: 0
- Forum: PostgreSQL Inc.: PostgreSQL
-
psql query output
Hello, When I am using psql on a new postgres server, sometimes the results are displayed in a new screen, almost like the result of a MAN command. I find this very annoying, but I don't know how I set it to always just print query results normally. Thanks for any help !- LD50
- Thread
- Replies: 1
- Forum: PostgreSQL Inc.: PostgreSQL
-
8.4.2 > 9.0.6 migration / pg_upgrade advice
Hello, I am preparing to do a major upgrade of a production postgres environment. Currently there is the live production db server, a WAL shipping warm standby server, and a reporting server that is synced using perl/SQL scripts and rebuilt weekly. I will also be changing operating systems...- LD50
- Thread
- Replies: 0
- Forum: PostgreSQL Inc.: PostgreSQL
