Re: [ADMIN] DB Structure Recovery

2008-03-21 Thread Simon Riggs
On Wed, 2008-03-19 at 16:56 +0200, veejar wrote: > My filesystem (UFS-FreeBSD) was crashed and I have lost files from > PGSQL DATA DIR FOLDER after fsck-utility. > > I have lost files from directory "pg_xlog" > I reset my pg_xlog. > > And now have such error by starting pgsql-server: > > LOG:

Re: [ADMIN] Postgres Performance

2008-03-21 Thread Steve Crawford
> I am using postgres 7.0 with linux with 15 GB of database & > 3 gb of RAM. Can anyone suggest what is the best setting > for postgres. I am using postgres as web db. You mentioned elsewhere that you are getting 2,000 hits/day. I don't know the nature of your web app but typical web apps involv