Hello List,
postgres 8.2 is not doing too much but eating up all my memory:
http://pastebin.com/m4cf22ee2
The postgresql.conf is at the very bottom of the pastebin.
I guess this is a configuration issue. The CPUs are almost 100% idle
but i seem to run out of memory.
Any idea what i could do here
Parameters like shared_buffers, work_mem are the ones you'll probably need
to adjust.
Work_mem is per user, and can actually be multiples per user, depending on
what you're doing.
On Fri, Aug 14, 2009 at 9:04 AM, ml ml wrote:
> Hello List,
>
> postgres 8.2 is not doing too much but eating up al
Peter Steinheuser writes:
> Parameters like shared_buffers, work_mem are the ones you'll probably need
> to adjust.
> Work_mem is per user, and can actually be multiples per user, depending on
> what you're doing.
temp_buffers is per-process too --- if there's heavy use of temp tables
in this ap
David,
You need to set your pg_hba.conf method to trust for your
connection and reload your configuration (service). That way you'll be
able to get into your database and change your pwd.
Regards,
gb.-
On Fri, Aug 14, 2009 at 11:49 AM, OldManRiver wrote:
>
> All,
>
> Do not use PG that often
Explain please!
Guido Barosio wrote:
>
> David,
>
> You need to set your pg_hba.conf method to trust for your
> connection and reload your configuration (service). That way you'll be
> able to get into your database and change your pwd.
>
> Regards,
> gb.-
>
> On Fri, Aug 14, 2009 at 11:4
Postgresql 8.2
When I do a full vacuum of our database I get the following:
NOTICE: relation "pg_class" TID 23/39: DeleteTransactionInProgress
4060299835 --- can't shrink relation
NOTICE: relation "pg_class" TID 31/31: InsertTransactionInProgress
4060299835 --- can't shrink relation VACUUM
Wha
OldManRiver wrote:
> Somehow it is not accepting the UID/PWD combo I set for this, and I have
> forgotten the defaults, so can not get in. I have been looking for the
> install notes to find the defaults but forgot where I put them and could not
> find online.
http://wiki.postgresql.org/wiki/FAQ#
Campbell, Lance wrote:
> Postgresql 8.2
>
> When I do a full vacuum of our database I get the following:
>
> NOTICE: relation "pg_class" TID 23/39: DeleteTransactionInProgress
> 4060299835 --- can't shrink relation
> NOTICE: relation "pg_class" TID 31/31: InsertTransactionInProgress
> 406029983
On Fri, Aug 14, 2009 at 7:04 AM, ml ml wrote:
> Hello List,
>
> postgres 8.2 is not doing too much but eating up all my memory:
> http://pastebin.com/m4cf22ee2
> The postgresql.conf is at the very bottom of the pastebin.
>
> I guess this is a configuration issue. The CPUs are almost 100% idle
> but
Oh I see that work_mem etc are in the pastebin. Yeah, 128M is pretty
high work_mem if all 75 connections are working hard that's 9.6Gig of
ram. which you haven't got.
On Fri, Aug 14, 2009 at 2:03 PM, Scott Marlowe wrote:
> On Fri, Aug 14, 2009 at 7:04 AM, ml ml wrote:
>> Hello List,
>>
>> postgr
Hello.
Let's say in a commercial environment where you install the database in a
customer's server and their IT people have admin/root access to this server.
How can we make sure that they don't get direct access to the database (e.g.
like editing pg_hba.conf and setting it to trust). We don't l
"chris.jurado" writes:
> Let's say in a commercial environment where you install the database in a
> customer's server and their IT people have admin/root access to this server.
> How can we make sure that they don't get direct access to the database (e.g.
> like editing pg_hba.conf and setting
12 matches
Mail list logo
