You increase max_fsm_pages and restart the server.
On Thursday 20 March 2008, Marc Fromm wrote:
> I received this message after running vacuum on a database.
>
> NOTICE: number of page slots needed (27296) exceeds max_fsm_pages
> (2)
> HINT: Consider increasing the configuration parameter "
Marc Fromm wrote:
Is there a better way to create a database from the schema of another
database, to have a copy of a database without the data?
1.) I get the schema from a database
pg_dump -s -U postgres -O databasename > /tmp/template_name
2.) I create a new database.
createdb -U postgres new
Aftab Alam wrote:
Dear All,
I am using postgres 7.0 with linux with 15 GB of database
& 3 gb of RAM.
Can anyone suggest what is the best setting for postgres. I am using
postgres as web db.
I'm going to assume/hope that you mean 8.0. Even then, you would be well
advised t
Dear All,
I am using postgres 7.0 with linux with 15 GB of database & 3 gb of
RAM.
Can anyone suggest what is the best setting for postgres. I am using postgres
as web db.
Regards
aftab
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION in
Bhella Paramjeet-PFCW67 wrote:
Thank you very much Shane for your response. I have one more question,
the firewall usually drops the idle connections. What can we configure
on the database side to keep the idle connections alive. In the
postgresql.conf file I see the parameter tcp_keepalives_idle
I¹m attempting to do something that should be a trivially simple task. I
want to do a data only dump from my production data in the public schema and
restore it on another machine. Both machines are running 8.2.5, both
machines are virtually identical and have 16GB of RAM.
I created an archive w
Thank you very much Shane for your response. I have one more question,
the firewall usually drops the idle connections. What can we configure
on the database side to keep the idle connections alive. In the
postgresql.conf file I see the parameter tcp_keepalives_idle, setting
this parameter would be
I received this message after running vacuum on a database.
NOTICE: number of page slots needed (27296) exceeds max_fsm_pages
(2)
HINT: Consider increasing the configuration parameter "max_fsm_pages"
to a value over 27296.
The documentation for 8.1 sates:
This setting must be more than 16
Is there a better way to create a database from the schema of another
database, to have a copy of a database without the data?
1.) I get the schema from a database
pg_dump -s -U postgres -O databasename > /tmp/template_name
2.) I create a new database.
createdb -U postgres newdb
3.) I restore th
Based on your conf file.. you can increase shared buffers and also you can
increase the max_connections. (I am not sure if your version of Postgres
supports more than 32 connections. Just check that). Apart from that you can
use Explain Analyze on any specific query which you think is having any
veejar escribió:
> When I have only folder base or base+global, can I read tables data
> from databases in such PGDATA via any tools or methods?
No, you need pg_clog at the very least. pg_xlog, pg_multixact and
pg_subtrans are almost equally important -- I think you could start
without them but
On Thu, Mar 20, 2008 at 10:42:29AM -0400, Tom Lane wrote:
> Ray Stell <[EMAIL PROTECTED]> writes:
> Define "wedged" --- what's the actual problem?
client queries not returning.
> If it is a locking issue then the pg_locks view might be useful.
duh, I meant to cut and paste the lock info and sen
This information I have found in PostgreSQL docs:
Table 52-1. Contents of PGDATA
PG_VERSION A file containing the major version number of PostgreSQL
baseSubdirectory containing per-database subdirectories
global Subdirectory containing cluster-wide tables, such as pg_database
pg_clog Su
2008/3/19, Achilleas Mantzios <[EMAIL PROTECTED]>:
> Στις Wednesday 19 March 2008 16:56:19 ο/η veejar έγραψε:
>
> > Hello!
> >
> > My filesystem (UFS-FreeBSD) was crashed and I have lost files from
> > PGSQL DATA DIR FOLDER after fsck-utility.
> >
> > I have lost files from directory "pg_xlog"
On Mittwoch, 19. März 2008 Campbell, Lance wrote:
> Would there be benefits in running PostgreSQL in a 32 bit mode on a
> 64 bit version of XP? My thought is that the OS could access more
> of the memory for the caching of the files. I come to this
> understanding because on my production Linux
Ray Stell <[EMAIL PROTECTED]> writes:
> I have a db wedged and need help dealing with it.
Define "wedged" --- what's the actual problem?
If it is a locking issue then the pg_locks view might be useful.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@
Any ideas or refeneces? Can be either for Unix or Windows
Thanks
Danny Abraham
BMC Software
CTM&D Business Unit
972-52-4286-513
[EMAIL PROTECTED]
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-adm
I have a db wedged and need help dealing with it. How can I
find out more about this, who, what, where, etc, and how
to free this up:
ghiza=# select * from pg_user;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil
| useconfig
-+--+-+---
Hi Vishal,
Attached is the conf file for your reference.
Regards
aftab
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vishal Arora
Sent: Thursday, March 20, 2008 4:34 PM
To: Aftab Alam; [EMAIL PROTECTED]
Cc: pgsql-admin@postgresql.org
Subject: Re:
> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> CC:
> pgsql-admin@postgresql.org> Subject: Re: [ADMIN] Postgres Performance> Date:
> Thu, 20 Mar 2008 16:02:48 +0530> > Dear Hubert,> > I have mistaken written
> 7.0 instead of 7.3, I am getting more than 2000 hits> daily, can u suggest
> th
On Thu, Mar 20, 2008 at 04:02:48PM +0530, Aftab Alam wrote:
> I have mistaken written 7.0 instead of 7.3, I am getting more than 2000 hits
> daily, can u suggest the best configuration. Mean while I am trying to
> migrate it to 8.3.1
7.3 is also pretty old.
as for 2000 hits daily - it's not much.
Dear Hubert,
I have mistaken written 7.0 instead of 7.3, I am getting more than 2000 hits
daily, can u suggest the best configuration. Mean while I am trying to
migrate it to 8.3.1
Regards
aftab
-Original Message-
From: hubert depesz lubaczewski [mailto:[EMAIL PROTECTED]
Sent: Thursday,
On Thu, Mar 20, 2008 at 03:12:43PM +0530, Aftab Alam wrote:
> I am using postgres 7.0 with linux with 15 GB of database & 3 gb
> of RAM.
> Can anyone suggest what is the best setting for postgres. I am using postgres
> as web db.
the best setting would be to upgrade.
7.0 was released
Dear All,
I am using postgres 7.0 with linux with 15 GB of database & 3 gb of
RAM.
Can anyone suggest what is the best setting for postgres. I am using postgres
as web db.
Regards
aftab
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION in
Bhella Paramjeet-PFCW67 wrote:
Hi
We will be setting up a production postgres database to which an
application will connect through a firewall. Can any one please tell me
if there is any configuration that needs to be done on the postgres
database side for firewall. Is there any documentation
25 matches
Mail list logo
