| From: | "Mark M(dot) Huber" <MHuber(at)VMdirect(dot)com> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | backup and recovery |
| Date: | 2004-03-18 20:08:00 |
| Message-ID: | C82819B1AE6E934A91FE8481153EB422A9E378@mail.co.vmdirect.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi all I am reasonable new to postgres so any direction that you can give in the regards I am sure will be helpful so thanks very much in advance.
I am not sure if I am doing something wrong or what exactly is going on. I have a db that I pg_dumped some tables out of and trying to recover them has taken more than 15 hours and these tables only one of them has over 500,000 rows so what am I missing?
It seams that any backup and recovery sucks. My main db backup takes over two hours to complete and 13 hours to recover what am I doing wrong? Any hints?ideas? Recommendations?
________________________________________
Mark M. Huber
DataBase Administrator
(702)-938-9300
markh(at)vmdirect(dot)com
http://www.vmdirect.com
3035 E. Patrick Lane
Suite #1
Las Vegas, NV 89120
<<Mark M. Huber.vcf>>
| Attachment | Content-Type | Size |
|---|---|---|
| Mark M. Huber.vcf | text/x-vcard | 132 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-03-18 20:42:56 | Re: PostgreSQL 7.3.4 to 4.2 Regresion Fails |
| Previous Message | V i s h a l Kashyap @ [Sai Hertz And Control Systems] | 2004-03-18 20:02:18 | Re: PostgreSQL 7.3.4 to 4.2 Regresion Fails |