Hi,
Gald to share that we have formed a tamil team to carry out the tamil
translation of postgres. We also have registered a web-site
http://postgres.org.in for the same. the site will be active in few days
time. The translation work has begun.
--
Sri Ramadoss M
Tamil Nadu, India
---
We have a cluster with four nodes, each running a postgres 7.4.8
database. Due to a large amount of pilot error and possibly hardware
problems (still trying to get to the bottom of it all), two of the
databases won't start, and I can't login to two others, with any
registered user.
Two of the node
Hello.
Facts:
1. System: Win2003
2. Postgres 8.2
3. Use pgAdmin 1.6.2, rev.5837 to administer the database
3. Table:
CREATE TABLE mt
(
suid character varying(70) NOT NULL DEFAULT 'suid'::character varying,
ris_match_row_idx integer DEFAULT -1,
ris_match_rule smallint DEFAULT 999,
stulev_matc
"Razvan Costea-Barlutiu" <[EMAIL PROTECTED]> writes:
> Hello.
>
> Facts:
> 1. System: Win2003
> 2. Postgres 8.2
Is that just 8.2 or 8.2.x? Which x?
> This has way too many ramifications for me to follow so I do appreciate some
> guidance.
What do the outputs of these queries say?
select count(
"Morris Goldstein" <[EMAIL PROTECTED]> writes:
> Two of the nodes have logs that look like this:
> 2007-09-22 07:06:05 [3060] LOG: could not open file
> "/var/lib/pgsql/data/pg_xlog/" (log file 0, segment
> 0): No such file or directory
> 2007-09-22 07:06:05 [3060] LOG: invalid p
On 9/22/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Morris Goldstein" <[EMAIL PROTECTED]> writes:
> > Two of the nodes have logs that look like this:
>
> > 2007-09-22 07:06:05 [3060] LOG: could not open file
> > "/var/lib/pgsql/data/pg_xlog/" (log file 0, segment
> > 0): No such fil
Sorry to reply to myself but here's a bit more info. That strace shows
a crash. The node that was denying logins is now complaining about
checkpoint file 000...000. It appears to be the case that a few
attempts to start converts a db that rejects logins to one that
crashes on startup. (When I first
On Friday 21 September 2007 22:43, Merlin Moncure wrote:
> On 9/21/07, Robert Treat <[EMAIL PROTECTED]> wrote:
> > On Thursday 20 September 2007 18:38, Merlin Moncure wrote:
> > > On 9/20/07, Collin <[EMAIL PROTECTED]> wrote:
> > > > Well, the subject says it pretty well but to elaborate:
> > > >
>
Gregory Stark <[EMAIL PROTECTED]> writes:
> "Razvan Costea-Barlutiu" <[EMAIL PROTECTED]> writes:
>> This has way too many ramifications for me to follow so I do appreciate some
>> guidance.
> What do the outputs of these queries say?
It would also be interesting to know whether REINDEXing the tab
On 9/22/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Morris Goldstein" <[EMAIL PROTECTED]> writes:
> > ...
> > 2007-09-22 07:06:05 [3060] LOG: could not open file
> > "/var/lib/pgsql/data/pg_xlog/" (log file 0, segment 0): No
> > such file or directory
> > ...
>
> ...
>
> You might
"Morris Goldstein" <[EMAIL PROTECTED]> writes:
> I looked at the pg_resetxlog documentation and have a question. Here
> is output from pg_resetxlog -n:
[ snipped to just the non-constant numbers ]
> Current log file ID: 0
> Next log file segment:1
> Latest checkpo
Tom, Gregory,
Thank you for your replies. I will try reindexing the table but I am not
very sure that will make any difference.
The reason is that when I built the table, I was building it making sure
there are unique values that get trown into it, in addition to the
constraint defined in the tabl
<[EMAIL PROTECTED]> writes:
> Hmm... maybe this will help: in the same function (i.e. transaction), I am
> also doing an update on the same table, using suid as update key, that is:
> update migratek.mt set sdate = smth where suid = s.suid;
Do the rows in the output to the second query I sent (th
13 matches
Mail list logo
