On Wed, Dec 06, 2006 at 10:45:08AM -0500, Schwenker, Stephen wrote:
> ... I know it's not
> the best solution but I couldn't get an answer fast enough because every
> time I send an email to the list, I get a message saying it was stalled
> and I have to wait for it to be approved by the moderator
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 05, 2006 4:09 PM
To: Glen Parker
Cc: Schwenker, Stephen; pgsql general
Subject: Re: [GENERAL] HELP: Urgent, Vacuum problem
On Tue, 2006-12-05 at 14:56, Glen Parker wrote:
> Scott Marlowe wrote:
> > On Mon, 2006-12-04
On Wed, 2006-12-06 at 10:15, Vivek Khera wrote:
> On Dec 5, 2006, at 4:09 PM, Scott Marlowe wrote:
>
> > I recently tossed 8.1 on my workstation which runs a little reporting
> > application here. I pointed the app from 7.4 to 8.1 and got a visit
> > within about an hour from a user, asking if I'
On Dec 5, 2006, at 4:09 PM, Scott Marlowe wrote:
I recently tossed 8.1 on my workstation which runs a little reporting
application here. I pointed the app from 7.4 to 8.1 and got a visit
within about an hour from a user, asking if I'd done anything to my
database. Worrying that I'd made some
On Tue, 2006-12-05 at 14:56, Glen Parker wrote:
> Scott Marlowe wrote:
> > On Mon, 2006-12-04 at 09:56, Schwenker, Stephen wrote:
> >> I'm using version 7.4.2 on solaris.
> >
> > A few points:
> >
> > 4: Look at migrating to 8.1 or even 8.2 (due out real soon now). There
> > have been a lot of
Scott Marlowe wrote:
On Mon, 2006-12-04 at 09:56, Schwenker, Stephen wrote:
I'm using version 7.4.2 on solaris.
A few points:
4: Look at migrating to 8.1 or even 8.2 (due out real soon now). There
have been a lot of advances in pg since 7.4, and the upgrade is pretty
painless as long as the
I'm pretty sure reindexing a table takes out an exclusive lock, which
means you might wanna wait til off hours to do one.
On Tue, 2006-12-05 at 13:26, John Sidney-Woollett wrote:
> To recover disk space, reindex the heavily updated tables. You can do
> this while the database is in production.
>
To recover disk space, reindex the heavily updated tables. You can do
this while the database is in production.
Check the REINDEX command.
John
Schwenker, Stephen wrote:
Hello,
I'm having a major Vacuuming problem. I used to do a full vacuum every
morning on my postgres database to clean
"Schwenker, Stephen" <[EMAIL PROTECTED]> writes:
> To fix that problem, I have turned off the full vacuum and are just
> doing a standard analyze vacuum.
Good.
> No I'm getting very close to running
> out of space on my disks because the table keeps on growing and the
> database is not re-using d
On Mon, 2006-12-04 at 09:56, Schwenker, Stephen wrote:
> Hello,
>
> I'm having a major Vacuuming problem. I used to do a full vacuum
> every morning on my postgres database to clean up empty space on a
> table but because of it's size, the locking of the database causes my
> application server t
Schwenker, Stephen wrote:
> I'm having a major Vacuuming problem. I used to do a full vacuum every
> morning on my postgres database to clean up empty space on a table but
> because of it's size, the locking of the database causes my application
> server to max out the database connections and ca
: [GENERAL] HELP: Urgent, Vacuum problem
Hello,
I'm having a major Vacuuming problem. I used to do a full vacuum every
morning on my postgres database to clean up empty space on a table but
because of it's size, the locking of the database causes my application
server to max out th
Hello,
I'm having a major Vacuuming problem. I used to do a full vacuum every
morning on my postgres database to clean up empty space on a table but
because of it's size, the locking of the database causes my application
server to max out the database connections and causes database errors.
To f
Usually 5432
Its listed in postgresql.conf, which could be in
/var/lib/pgsql/data/
or
/usr/local/pgsql/data
Terry
ElayaRaja S wrote:
I am facing TCP IP connection refused.
But i enbled the tcpip as true and i like to know the port number.
becuase i like to enble the port number in my firewall. Plea
I am facing TCP IP connection refused.
But i enbled the tcpip as true and i like to know the port number.
becuase i like to enble the port number in my firewall. Please let me
know
Note: i can able to connect with my local ip address. The issue which
i faced when i access through the public ip add
ElayaRaja S schrieb:
> Hi,
>I am using Redhat Linux 9 and PostgreSQL 7.4.5. While shutdown the
> linux server i forget to stop the postgresql. After starting the linux
> server, now i am unable to stop the postgres. When stopping the
> postgres i am getting the following error as
>
> bash-2.0
Hi,
I am using Redhat Linux 9 and PostgreSQL 7.4.5. While shutdown the
linux server i forget to stop the postgresql. After starting the linux
server, now i am unable to stop the postgres. When stopping the
postgres i am getting the following error as
bash-2.05b$ pg_ctl status
pg_ctl: postmaste
17 matches
Mail list logo
