Hope there is bad sector. Did u checked restoring the backup DB to ur local
server?
On Wed, Sep 23, 2009 at 9:50 AM, nalini wrote:
> Backup is with pg_dump -Ft command ie tar backup
>
>
> - Original Message -----
> From: S Arvind
> Date: Tuesday, September 22, 2009 6:1
Is the backup is made by pg_dump or copying the entire data folder?
-Arvind S
"Many of lifes failure are people who did not realize how close they were to
success when they gave up."
-Thomas Edison
On Tue, Sep 22, 2009 at 5:01 PM, nalini wrote:
> I am unable to recover my data due hard disk
server start paging more than it ever used to do.
>
> Check your vmstat and iostat information at the time of the slowdown, and
> see if you can determine whether you're paging or waiting on storage. I
> suspect you'll find that throwing hardware (memory, as a guess
; performance problems, so I do that once per week, myself.
>
> -Original Message-
> From: pgsql-admin-ow...@postgresql.org
> [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of S Arvind
> Sent: Monday, September 21, 2009 12:46 PM
> To: pgsql-admin
> Subject: [ADM
Recently due to some problem(not yet diagnosed) , our DB server Postgres is
getting very slow after few hours. We didnt changed any settings for 6
months , so we dont know y its happening suddenly in this week. Our data
folder is 118GB with 160 DBs. System is 2 Quad core with RAM 4GB. In last
two d
Devrim i found out and its working fine... Very thanks...
-Arvind S
*
"Many of lifes failure are people who did not realize how close they were to
success when they gave up."
-Thomas Edison*
On Thu, May 14, 2009 at 10:00 PM, S Arvind wrote:
> Thanks Devrim,
> I can und
ld.so.conf.d/*.conf
i tried including that but got error while ldconfig
can u pls tell how to implement...
*
"Many of lifes failure are people who did not realize how close they were to
success when they gave up."
-Thomas Edison*
2009/5/14 Devrim GÜNDÜZ
> On Thu, 2009-05-14 at 1
after installing pg_top, when i tried to start it, i got this msg, how to
solve it
# pg_top
pg_top: error while loading shared libraries: libpq.so.5: cannot open shared
object file: No such file or directory
--Arvind S
*
"Many of lifes failure are people who did not realize how close they were t