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
Hi Shridhar,
Probably you should read a bit about how PostgreSQL locks and what
operation requires which locks. More importantly what happens when these
locks are not available.
ISTM, your trigger operation tries a bulk operation
(INSERT/DELETE/UPDATE) on table B but the nightly reindex acqu
It'd help to know what Pg version you're running. Comments inline below.
On 11/10/2011 07:01 PM, Thorsten Strufe wrote:
sorry, noob here. So we've just started using postgre and right at the
start we had a hardware problem with a hard drive failing. We can still
start postgre but a tablespace f
Hi,
I am experience the problem where locks acquired by postgres are NOT getting
released.
The use case is something like:-
. There is a table let's say "A" and the trigger is created on this
table let say "A_TRIGGER".
. The trigger captures the data change happens in
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
Thorsten Strufe wrote:
> is there any (sane) way to simply get postgre to entirely forget
> about the broken db - and that's it (dumping the other db and
> loading it back might not be the best solution, since it's rather
> large..)?
I think that using pg_dump for the good databases is sane, a
Steve Crawford wrote:
On 11/09/2011 11:41 AM, Geoffrey Myers wrote:
Geoffrey Myers wrote:
Tom Lane wrote:
Steve Crawford writes:
On 11/09/2011 05:10 AM, Geoffrey Myers wrote:
Is there a way to retain this information from the original
database when reloading?
Time-zone setting is an attri
On Nov 10, 2011, at 7:01 AM, Karuna Karpe wrote:
> what's wrong in above. why not able to connect to database??
Your disk is full?
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
Karuna Karpe wrote:
> 2011-11-10 18:46:40 ISTPANIC: could not write to file
> "pg_xlog/xlogtemp.8737": No space left on device
> 2011-11-10 18:46:40 ISTLOG: startup process (PID 8737) was
> terminated by signal 6: Aborted
What does df show if you run it at that point?
-Kevin
--
Sent via
Hello,
I am loading data in "demo" database table "emp". I use folloing
command :-
enterprisedb@linux-pgbulk:~/bin> ./edbldr -d demo userid=enterprisedb/psql
control=/opt/PostgresPlus/user_tablespace/control_file.ctl
EDB*Loader: Copyright (c) 2007-2011, EnterpriseDB Corporation.
edbldr error
Hi everybody,
sorry, noob here. So we've just started using postgre and right at the
start we had a hardware problem with a hard drive failing. We can still
start postgre but a tablespace for a db that we don't even need anymore
is lost. Now we would think that shouldn't be a problem, we could sim
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
12 matches
Mail list logo
