Hi,
I have a postgres 8.3 db in which I execute a transaction with a lot of alter
tabel etc, update etc statements in a single transaction.
I also execute several select statements in parallel.
This puts my database in a state which I would describe as halted, i.e. the sql
interface does not re
On Tue, Oct 20, 2009 at 8:46 AM, stefan wrote:
>
> Hi,
>
> I have a postgres 8.3 db in which I execute a transaction with a lot of
> alter tabel etc, update etc statements in a single transaction.
> I also execute several select statements in parallel.
> This puts my database in a state which I w
I ocassionally get this error when a large insert is made to a very
large table (Postgres 8.1.9)
Hardware is 8 core Dell 2950 with 6x300G Raid 10 Disk setup.
LOG: server process (PID 25002) exited with exit code 1
LOG: terminating any other active server processes
WARNING: terminating connecti
Radamanthus Batnag writes:
> I have a PostgreSQL production server running on CentOS (compiled from
> source), and I'm planning to setup a hot standby database on another
> server, running on Ubuntu (default Ubuntu binaries).
> The production server is running on 8.3.5, and the planned Ubuntu
On Tue, Oct 20, 2009 at 9:25 AM, Tom Lane wrote:
> OS per se shouldn't matter
>
unless you try to do it between windows and some flavor of linux
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent
Jaime Casanova writes:
> On Tue, Oct 20, 2009 at 9:25 AM, Tom Lane wrote:
>> OS per se shouldn't matter
> unless you try to do it between windows and some flavor of linux
hmmm ... even there, the only risk factor I see would be incompatible
locale behaviors, which you could avoid by making sure
Hi everybody,
Is there any quick way to list attributes of table?
As I type at psql prompt:
\dt+ foo.mytable*
It gives me 5 columns (schema, name, type, owner, and
description) of tables named mytable1, mytable2, etc.
in the schema foo.
What I want would be the last modification date of each
Hi.
We use PostgreSQL 8.4.1 on linux.
In one of the databases we use we see the following problem.
database=# \d table001
ERROR: column "reltriggers" does not exist
LINE 1: SELECT relhasindex, relkind, relchecks, reltriggers, relhasr...
^
As i
Could you perhaps be using an old version of psql (prior to 8.4.0)? 8.4.0
dropped using that and now uses relhastriggers.
-Original Message-
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of k_b0...@yahoo.se
Sent: Tuesday, October 20, 2009 12:
k_b0...@yahoo.se writes:
> We use PostgreSQL 8.4.1 on linux.
> In one of the databases we use we see the following problem.
> database=# \d table001
> ERROR: column "reltriggers" does not exist
> LINE 1: SELECT relhasindex, relkind, relchecks, reltriggers, relhasr...
>
On Tue, Oct 20, 2009 at 10:11 AM, Tena Sakai wrote:
> Hi everybody,
>
> Is there any quick way to list attributes of table?
> As I type at psql prompt:
>
> \dt+ foo.mytable*
>
> It gives me 5 columns (schema, name, type, owner, and
> description) of tables named mytable1, mytable2, etc.
> in the
Anj Adu writes:
> I ocassionally get this error when a large insert is made to a very
> large table (Postgres 8.1.9)
> LOG: server process (PID 25002) exited with exit code 1
The interesting messages would be before that one, I think. This
should indicate a FATAL exit, and that should have got
Of course you are right.
It turns out that the machine i connected from did not have an upgrade of
postgresql. After upgrading it all works!
Thank you!
2009-10-20 13:16 Plugge, Joe R. wrote:
Could you perhaps be using an old version of psql (prior to 8.4.0)? 8.4.0
dropped using that and
The only FATAL message when the error occurred was this
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back
the current transaction and exit, because another server process
exited abnormally and possibly
Hi Scott,
Thank you for your reply.
> That information is not stored by the db really,
> so there's no way to get it.
I think then I would build another column for
timestamp. But in object-oriented lingo, this
would be a class field, rather than instance
field, and I don't want to timestamp eve
On Tue, Oct 20, 2009 at 2:42 PM, Tena Sakai wrote:
> Hi Scott,
>
> Thank you for your reply.
>
>> That information is not stored by the db really,
>> so there's no way to get it.
>
> I think then I would build another column for
> timestamp. But in object-oriented lingo, this
> would be a class f
Hi Scott,
> Do you mean when the table was modified
> (i.e. alter table add column) or when the
> data in the table was changed?
I mean the latter, the data change.
> If it's when the table was changed, the
> easiest way is to store that in the comment
> for the table whenever you alter it.
Gre
Anj Adu writes:
> We do have java code called by pl/java...but there seems to be no
> indication on why the crash occurred.
Would that code be getting invoked while the problematic command
executes? If so I think you need to look into the java stuff to
see what might make it decide to termin
Greg Stark escribió:
> On Mon, Oct 19, 2009 at 8:56 PM, Tom Lane wrote:
> > Greg Stark writes:
> >> The run-time of CLUSTER doesn't vary very much based on whether the
> >> data is already in index order or not. The number of passes only grows
> >> like log(n) of the size of your data and if you
On Tue, Oct 20, 2009 at 9:03 PM, Alvaro Herrera
wrote:
> Greg Stark escribió:
>> On Mon, Oct 19, 2009 at 8:56 PM, Tom Lane wrote:
>> > Greg Stark writes:
>> >> The run-time of CLUSTER doesn't vary very much based on whether the
>> >> data is already in index order or not. The number of passes on
On Tue, Oct 20, 2009 at 10:56 AM, Tom Lane wrote:
> Jaime Casanova writes:
>> On Tue, Oct 20, 2009 at 9:25 AM, Tom Lane wrote:
>>> OS per se shouldn't matter
>
>> unless you try to do it between windows and some flavor of linux
>
> hmmm ... even there, the only risk factor I see would be incompa
21 matches
Mail list logo
