Re: [ADMIN] how do you manage postgres 9's postgres process's memory

2011-02-18 Thread Kevin Grittner
Keith Gabryelski wrote: > any pointers for me to educate myself on these things is greatly > appreciated (a book?, google fu, web links?) http://www.postgresql.org/docs/books/ http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server -Kevin -- Sent via pgsql-admin mailing list (pgsql

Re: [ADMIN] replication of whole database from one machine to another

2011-02-18 Thread Kevin Grittner
amjad usman wrote: > now i want to copy the same data on the other machine for testing > some queries. > > can anybody tell me how i can do this? You have many options. You can review them in the documentation here: http://www.postgresql.org/docs/9.0/interactive/backup.html > secondly, m