Re: [ADMIN] error log, tablespace, wal files

2011-11-10 Thread Karuna Karpe
Thanks to all for giving solution. On Fri, Nov 11, 2011 at 8:24 AM, Craig Ringer wrote: > On 11/10/2011 02:29 PM, Karuna Karpe wrote: > > 1) what is tablespace in postgres? >> > > It's a way of putting some tables, indexes, etc into a different part of > your system's storage. Sometimes yo

Re: [ADMIN] error log, tablespace, wal files

2011-11-10 Thread Craig Ringer
On 11/10/2011 02:29 PM, Karuna Karpe wrote: 1) what is tablespace in postgres? It's a way of putting some tables, indexes, etc into a different part of your system's storage. Sometimes you want to do this to put a really big table on slower, cheaper storage. Sometimes you might want to

Re: [ADMIN] error log, tablespace, wal files

2011-11-10 Thread Scott Marlowe
On Thu, Nov 10, 2011 at 12:36 AM, Uwe Schroeder wrote: > > >> Hello, >> >>      1) what is tablespace in postgres? >> >>      2) one more issue is that, I try to rename or delete some file in >> /opt/PostgresPlus/9.0/data/base/16428/ directory.  when I restart postgres >> server, it start normally

Re: [ADMIN] error log, tablespace, wal files

2011-11-09 Thread Uwe Schroeder
> Hello, > > 1) what is tablespace in postgres? > > 2) one more issue is that, I try to rename or delete some file in > /opt/PostgresPlus/9.0/data/base/16428/ directory. when I restart postgres > server, it start normally. but I thing this is wrong. I rename or delete > file into a

[ADMIN] error log, tablespace, wal files

2011-11-09 Thread Karuna Karpe
Hello, 1) what is tablespace in postgres? 2) one more issue is that, I try to rename or delete some file in /opt/PostgresPlus/9.0/data/base/16428/ directory. when I restart postgres server, it start normally. but I thing this is wrong. I rename or delete file into above directory, th