=?iso-8859-1?Q?R=E9my_Dufour?= <[EMAIL PROTECTED]> writes:
Recently, I've installed postgres 6.5 on a P3 450 396 megs of RAM. I'm
> running Linux RedHat 6.2. I got a few db on it and one has around 2 million=
> s records. When I boot my server, I do a 'free' and it tells me that I got =
> around
Michael Holopainen wrote:
>
> How do I set datestyle to European in server end ?
>
> I tried running postmaster with "-oe" as instructed in one email, but it
> resulted as error it did not accept -oe.
> for moment I all connections set datestyle = European, but it's not
> enough.
This can be se
No religious war happening here. Linux is what I've got set up at work and
at home, and it's where I've got most of my Unix experience from. I'm
thinking of putting OpenBSD or FreeBSD on one of my boxes at home, though,
just to try it out.
The thing I like about having a firewall that does port
i figured out in launching strace postmaster :)
and seeing some open failing, causing the master postmaster to crash and
with it all it's sons. It was with a PG 6.5.3, and I haven't seen it happen
again since a added an
echo 16384 > /proc/sys/fs/file-max
in my rc.local.
Mike Field wrote:
>
> Th
Here, we have a similar problem. When there are about 34 psql processes
running and one more gets added, all turn to zombies. The only way to get
Postgres running again is to restart it.
Postgres version 6.4
Linux version 2.0.36
J.D.
On Thu, 6 Jul 2000, Mike Field wrote:
>
> Hi-
>
>
Thanks for the tips. A few questions: how does the lack of filehandles
relate to the postmaster crashing? Filehandles to what files? How did you
figure it out? (ie. did you look at logs? If so, which and how?)
Thanks in advance for the help.
Mike
[EMAIL PROTECTED]
- Original Message
-Original Message-
From: Michael Holopainen [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, July 05, 2000 7:46 AM
Cc: [EMAIL PROTECTED]
Subject:[ADMIN] how do I set DateStyle = European in postmaster ?
>How do I set datestyle to European in server end ?
>
>I tried running post
I've had quite the same thing on a busy server, it was due to a lack of
filehandles.
Mike Field wrote:
>
> Hi-
>
> My php website interacts with a postrgres database, and every now and then,
> postgres just seems to crash. A simple restart of postmaster fixes the
> problem, until it crashe
Just to let Mike know that he is not alone, I have the exact same
problem. It is sooo annonying that postmaster will just crash about once a
week at various times. My question is how can the pg_log file be
viewed? I have a good idea at what time the postmaster crashed, but do
not know what post
Hi-
My php website interacts with a postrgres database, and every now and then,
postgres just seems to crash. A simple restart of postmaster fixes the
problem, until it crashes again. However, I have no idea EXACTLY when it
crashes (what the website users are doing at the time, if anything
On Wed, 5 Jul 2000, Yadira M. Rodriguez wrote:
> Hi,
>
> I'm getting this error: "No such function 'to_char' with the specified
> attributes" when trying to select a timestamp type field. For example:
> "select to_char(col_name, 'MM-DD-') from table_name". Is there
> somebody that can he
I am trying to set up a pgsql server, and I don't know too much about
this (or any other) database. When I try to initdb, it dumps telling my
"Error: Unknown type: oidvector"
and then it cleans up, dumps out.
Anybody out there know what is going on?
Rob
[EMAIL PROTECTED]
Hi there,
Recently, I've installed postgres 6.5 on a P3 450
396 megs of RAM. I'mrunning Linux RedHat 6.2. I got a few db on it and one
has around 2 millions records. When I boot my server, I do a 'free' and it tells
me that I got around 300 megs of RAM free.
After I do a couple of request
Hi,
I'm getting this error: "No such function 'to_char' with the specified
attributes" when trying to select a timestamp type field. For example:
"select to_char(col_name, 'MM-DD-') from table_name". Is there
somebody that can help me with this?
Thanks,
Yadira
How do I set datestyle to European in server end ?
I tried running postmaster with "-oe" as instructed in one email, but it
resulted as error it did not accept -oe.
for moment I all connections set datestyle = European, but it's not
enough.
please, help1
-michael (A)
Len Morgan wrote:
Hellow everyone,
At this moment I am developing a website with PostgreSQL 7.01 as
database engine. I like to create a front-end with MS Access/Visual Basic to
do some administrative jobs. At this moment, i have some questions.
1. How much stable postgres is in case of unstable tcp/ip connecti
16 matches
Mail list logo
