Well, first of all, max_connections can only be set at server start.
Are you restarting postgres when you do "trial and error changes"?
Secondly, 5 users can still manage to make multiple connections. You
can use ps to see how many connections are active at any given time.
http://www.postgresql
Hi Tom,
> pg_xlog shouldn't grow unreasonably big unless you've somehow turned off
checkpointing. pg_clog shouldn't grow unreasonably big unless you've
neglected
> appropriate vacuuming procedures (see the manual). So I think this is
mostly pilot error.
After going through the manual, I chang
Original Message
Subject:
Downloading plugins
Date:
Mon, 07 Mar 2005 12:55:15 -0500
From:
Jananeh Asari <[EMAIL PROTECTED]>
To:
[EMAIL PROTECTED]
Hi there:
I am trying to us
I did:
Start | Run | mmc | OK.
File | Add/Remove Snap-in | Add... | Local
Users and Groups | Add | Local computer. | Finish.
(A message reading, “This computer
is running Windows XP Home Edition. This snapin may not be used with that
version of Windows. To manage user accounts for this c
Hi Experts,
I work with
postgresql 8.0 version. I have a team of 14 developers. When all the team
connects the DB i see this error very very frequently which is a severe problem
for me and team all the day. The error is:
Please report this exception: java.sql.SQLException: FAT
Bonjour,
J'ai un problème sous Postgres que j'ai installé sous Linux.
Je me connecte en tant qu'utilisateur Postgres et quand je veux faire
par exemple une création de base de données (enfin n'importe quelle
opération sous Postgres), il m'est demandé un mot de passe et je ne m'en
sors pas.
Avez-vou
i work with php and postgres,but i have a
problem.when i whrite my program in php with postgres function
(pg_connect for esample),the browser told me that is undefined function ,it's
very strange because i compil the php source with support of pgsql
(--with-pgsql)...
why can i resolv
Hello list,
I just want to upgrade from 7.4.2 to 7.4.7 on Fedora Core 1. Is it
safe to simply
download the 7.4.7 rpms and then install/upgrade them with:
rpm -U postgresql-7.4.7.rpm
Kind Regards,
Devin
---(end of broadcast)---
TIP 1: subscribe and
On Mon, Mar 07, 2005 at 03:33:33PM -0800, Tomeh, Husam wrote:
>
> Is the postgreSQL source available on the ftp site (for instance,
> /source/v8.0.1/postgresql-base-8.0.1.tar.gz) works on all Unix
> environment. In particular Sun Solaris? I'll be installing PostgreSQL on
> Solaris 2.8.
The Postgr
unsuscribe
___
250MB gratis, Antivirus y Antispam
Correo Yahoo!, el mejor correo web del mundo
http://correo.yahoo.com.ar
---(end of broadcast)---
TIP 9:
Or at least it seems that way.
I have Pg 8.0.1 from the PGDG RPMs installed in a Linux-Vserver ( which
I have used before with Pg 7.2 and 7.3 ). I have changed the
postgresql.conf file and added/modified the listen_addresses to the
Vserver's IP. In pgstartup.log I always see these lines after
Hi,
Is the postgreSQL source available on the ftp site (for instance,
/source/v8.0.1/postgresql-base-8.0.1.tar.gz) works on all Unix
environment. In particular Sun Solaris? I'll be installing PostgreSQL on
Solaris 2.8.
Thanks,
***
I am runnning postgres 7.1.3 on RH 7.2. I am using Lyris Listmanager
6.1
I have been running this way for 2 years - no problems!
Today postgres quit. I am unable to start postgres. I receive this
error:
[EMAIL PROTECTED] bin]$ ./pg_ctl start
[EMAIL PROTECTED] bin]$ FATAL 2: control file context
Does this modified example from the documentation not cover your case?
# The zero mask means that no bits of the host IP
# address are considered so it matches any host.
hostall all 0.0.0.0 0.0.0.0 md5
http://www.postgresql.org/docs/7.4/static/client-authenti
---(end of broadcast)---
TIP 8: explain analyze is your friend
De:
[EMAIL PROTECTED]
Para:
pgsql-admin@postgresql.org
Copia:
Fecha:
Fri, 25 Feb 2005 22:11:55 +0200
Asunto:
[ADMIN] unsubscribe
unsubscribe
inugamy sanamichi
AMATERAZUS
___
¡Sobre autos lo sabemos todo, y te
On Mon, Mar 07, 2005 at 09:04:04PM +0530, Gourish Singbal wrote:
> Hi,
>
> Can anybody provided me the procedure to take online backups in 8.0.1.
> Simple steps would be really great..
>
> --
> Best,
> Gourish Singbal
>
> ---(end of broadcast)---
Lai, Eric wrote:
>
> I was wondering if you know where I could find specifications on the
> PostGresSQL 7.4.3 (the one build one used). I have information such as:
>
> Maximum size for a database? unlimited (60GB databases
> exist)
> Maximum size for a table?16 TB
>
On Mon, Mar 07, 2005 at 09:04:04PM +0530, Gourish Singbal wrote:
> Can anybody provided me the procedure to take online backups in 8.0.1.
> Simple steps would be really great..
Does the "Backup and Restore" chapter in the documentation not
answer your questions? If not, could you be more specifi
John DeSoi mentioned :
=> I'm not sure you can use \d directly, but if you startup psql with the
=> -E option it will show you all the SQL it is using to run the \d
=> command. It should be fairly easy to get the strings you need from the
=> results of running a similar query. The psql source is
Hello,
I read some articles about PGSQL tuning (7.4.x).
We have a dedicated DB server with 6 GB of RAM. So I'm trying to
determine the the size of my shared buffers.
Ho wcan I find the biggest size of a database ?
Thanks,
---(end of broadcast)---
TI
My favorite for this task is WinSql available from
http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp. It can compare
the structure and content of the two tables.
-Original Message-
From: John DeSoi [mailto:[EMAIL PROTECTED]
Sent: Monday, March 07, 2005 7:40 AM
To: Stef
Cc: pgsql-A
Tom Lane mentioned :
=> > The problem I have with this, is that I have to run the command per table,
=>
=> Why?
=>
=> If the problem is varying order of table declarations, try 8.0's
=> pg_dump.
Yes, this will solve the global schema check, but I will still need to split
it into "per table" dump
Hi,
Can anybody provided me the procedure to take online backups in 8.0.1.
Simple steps would be really great..
--
Best,
Gourish Singbal
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Mar 7, 2005, at 10:09 AM, Stef wrote:
Is it possible to somehow pass the output of : "\d [TABLE NAME]"
to this function? If not, what would return me consistent text
that will describe the columns, indexes and primary keys of a table?
I'm not sure you can use \d directly, but if you startup psql
Markus Schaber mentioned :
=> Some weeks ago, I posted here a script that uses psql to create split
=> dumps. Maybe you can reuse some of its logics to create per-table
=> md5sums for all tables in a database automatically.
Thanks, but I've got something very similar to this already. I almost
tho
Title: Help on maintaining pgsql/data folder size
Are
you aware of the SQL command >VACUUM< and its
variants?
And
CLUSTER?
-Original Message-From: Pradeepkumar, Pyatalo (IE10)
[mailto:[EMAIL PROTECTED]Sent: Montag, 07. März
2005 08:08To: pgsql-admin@postgresql.orgSubject: [AD
John DeSoi mentioned :
=> Develop a function that builds a string describing the tables/schemas
=> you want to compare. Then have your function return the md5 sum of the
=> string as the result. This will give you a 32 character value you can
=> use to determine if there is a mismatch.
OK, this
Radtchenko Igor <[EMAIL PROTECTED]> writes:
> But now, after I've installed 8.0.1, it says things as examples in
> little attach.
> freenibs=# CREATE FUNCTION public.if(int4, int4, int4) RETURNS int4 AS '
> freenibs'# DECLARE
> freenibs'# expr1 ALIAS FOR $1;
> freenibs'# expr2 ALIAS FOR $2;
> ..
"Pradeepkumar, Pyatalo (IE10)" <[EMAIL PROTECTED]> writes:
> I am using PostgreSQL 7.4.3. The problem I am facing is that the size of
> pgsql/data folder keeps increasing and at a point the it takes up all the
> disk space and it freezes the system. The pg_xlog and the pg_clog folders
> are taking
Stef <[EMAIL PROTECTED]> writes:
> Markus Schaber mentioned :
> => But maybe a pg_dump --schema-only on all the databases, and then
> => manually diffing the files may already fulfil your needs.
> I've tested something similar, that seems to work ok for me for now :
> pg_dump -s -t [TABLE] [DBNAME
[EMAIL PROTECTED] mentioned :
=> Are you just synching the schemas, or do you also need to synch the data?
Schemas now, data later.
To do the data part, I'm thinking of using slony, because it seems to be able to
do pretty much everything I need from that side. But, unfortunately I can't
even st
Are you just synching the schemas, or do you also need to synch the data?
Rick
John DeSoi
Hi, Stef,
Stef schrieb:
> The problem I have with this, is that I have to run the command per table,
> and seeing that I have over 500 tables in each database, this takes quite a
> long time.
Some weeks ago, I posted here a script that uses psql to create split
dumps. Maybe you can reuse some o
Markus Schaber mentioned :
=> There are (at least) two independently developed pgdiff applications,
=> they can be found at:
=>
=> http://pgdiff.sourceforge.net/
=>
=> http://gborg.postgresql.org/project/pgdiff/projdisplay.php
Thanks a lot!
=> I did not try the first one, but the latter one wor
On Mar 7, 2005, at 4:33 AM, Stef wrote:
I have the wonderful job of re-synch'ing all the schemas out there not
conforming to the master. I've looked everywhere for something that
will help doing this. I'm specifically looking for a way to do a
sumcheck
or something similar on tables and/or schema
Hi, Stef,
Stef schrieb:
> It will be a bonus to pick up exactly what is missing, but for now, just
> identifying
> differences is what I want to achieve. I'm using postgres 7.3 mostly, but
> I may want to use this for 7.4 and 8.0 databases as well.
>
> Has anybody got some suggestions of what
Hello Tom,
Thank you very much for such fast reply.
But now, after I've installed 8.0.1, it says things as examples in
little attach.
<--
Where I have to dig?.. :(
Sunday, March 06, 2005, 2:38:26 AM, you wrote:
TL> Igor Radtchenko <[EMAIL PROTECTED]> writes:
>> CREATE FUNCTION public.from_d
Hi all,
I've got a master database with many other databases that
all have (or is supposed to have) the same exact same schema
as the master database (the master database is basically an empty
template database containing the schema definition).
The problem is that none of the schemas actually
39 matches
Mail list logo
