On Sat, Dec 11, 2004 at 22:55:55 -0500,
Ron Peterson <[EMAIL PROTECTED]> wrote:
>
> I have:
>
> hostall all 127.0.0.1 255.255.255.255 md5
> hostall all 127.0.0.1 255.255.255.255 pam
> postgresql
> hostall all 0.0.0
Good day to all ...
I hope any one can give me an advice ... to optimize my database...
im having a problem when i'm backing up my DB and also using vacuum for my
DB...
my CPU load goes up and no one can use my DB... most of the transaction
comes from web server..
I just need ur good advice
On Sat, Dec 11, 2004 at 01:51:07PM -0600, Bruno Wolff III wrote:
> On Fri, Dec 10, 2004 at 20:50:56 -0500,
> Ron Peterson <[EMAIL PROTECTED]> wrote:
> > On Fri, Dec 10, 2004 at 03:20:50PM -0500, Ron Peterson wrote:
> >
> > > Sometimes, however, I would like to create an account in PostgreSQL
> >
Hello,
We are interested in installing the pgcrypto module of PostgreSQL for
Windows,
In order to use the function digest() for creating index on bytea type
fields:
create unique index my_index on my_table (digest(my_bytea_field,
'md5'));
HOW CAN WE I
On Fri, Dec 10, 2004 at 20:50:56 -0500,
Ron Peterson <[EMAIL PROTECTED]> wrote:
> On Fri, Dec 10, 2004 at 03:20:50PM -0500, Ron Peterson wrote:
>
> > Sometimes, however, I would like to create an account in PostgreSQL
> > which I do not want to also maintain in LDAP. Is it possible to
> > confi
Please unsubscribe from mailing list.
-Deepak
__
Do you Yahoo!?
The all-new My Yahoo! - What will yours do?
http://my.yahoo.com
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Fri, Dec 10, 2004 at 21:14:10 -0800,
Joe Conway <[EMAIL PROTECTED]> wrote:
> Mª José Sempere wrote:
> >We are interested in installing the pgcrypto module of PostgreSQL for
> > Windows, In order to use the function digest() for creating index on
> >bytea type fields:
> >
> >create unique index
"Chris White (cjwhite)" <[EMAIL PROTECTED]> writes:
> Also, I found by re-indexing the pg_largeobject table the problem seems to
> have gone away.
Um. That's probably destroyed the evidence :-( ie gotten rid of
whatever weird state you'd gotten the index into. But if you have
any luck reproducin
"Chris White (cjwhite)" <[EMAIL PROTECTED]> writes:
> I am putting a large object into my database using jdbc interface and using
> LargeObjectManager to do largeobject open, write and close. After several
> largeobject writes I get the following message
> 'failed to re-find parent-key in "pg_lar
On Tue, Dec 07, 2004 at 06:17:48PM -, Ari Johannesson wrote:
> I have data to import into a postgres database. The data is referentially
> sound but during the insert it breaks som foreign-key constraints. Is there
> a way to turn off the referential integrity during the insert?
You could mak
Do the pg_dump/pg_dumpall utility programs generate any
return codes that I could analyze to determine the success or failure of the
PostgreSQL database backups? It would
seem logical that they should. Please advise, and point
me to a piece of doc that might be of help if it exists.
Thanks in
HI,
I am working on a project, in which a part of it deals with creating a table on different nodes of a Beowulf cluster.
Each of the nodes in the cluster is running a postmaster on different cluster. There is one master node in this cluster.
I am trying to run the postmaster on the port 9010
I have data to import into a postgres database. The data is
referentially sound but during the insert it breaks som foreign-key
constraints. Is there a way to turn off the referential integrity during the
insert?
Thanks,
Ari Johannesson
Hi
I did a very small but terrible mistake with my database.
I installed postgresql and DSpace for use in the INSTITUTO ANTONIO CARLOS JOBIM, dedicated to the work of this famous Brasilian composer.
I first installed a version 8.0beta5 of postgres but a software advisor asked me to use a formal rel
Hi
I am trying to create a database using JDBC.
I am working in a beowulf cluster, where there is one master node, and
many client nodes.
Right now I want to create JDBC on the master node, and three client nodes.
The postmaster is running on all four of them, the postmaster is using
/tmp/data d
This is 7.4.5. I'm not sure I can get it to happen on an empty database, the
database this is happening on has about 300 large objects, but I will try.
Also, I found by re-indexing the pg_largeobject table the problem seems to
have gone away.
Chris White
-Original Message-
From: Tom Lane
The code given below gives an exception as:
a suitable driver not found.
I am not working on a network, it is a simple stand alone PC.
Which SqlDriverr would be suitable,I am using SqlServerDriverfor SQl database 7.0,j2sdk1.41_01 and have installed SqlServerDriver driver sqlserverdriver.ja
Hi,
I'm planing a file system type application for postgres, reading the
docs a question arise:
shall I put the files as large objects in the db, or kept them separately?
Reading the docs it seems to me, that large objects can hold data up to
2GB in size. Is this still true, or will that restrict
Please unsubscribe from mailing list.
-Deepak
__
Do you Yahoo!?
Jazz up your holiday email with celebrity designs. Learn more.
http://celebrity.mail.yahoo.com
---(end of broadcast)---
TIP 8: expl
Dear Deepak ,
This is your second such request. Please follow the steps given below.
We understand that you subscribed to our mailing list with some
specific reasons. If so we hope that you have achive your purpose in
case you feel short of information please do mail us.
In order to unsubscribe
"John Jensen" <[EMAIL PROTECTED]> writes:
> The job is clearly cpu bound in the postmaster process.
Which part of the dump process is CPU bound --- dumping schema, or data?
(Try enabling log_statement for the pg_dump run and correlating the
appearance of queries in the postmaster log with the CPU
[EMAIL PROTECTED] writes:
> Is there a setting in postgresql.conf that will log the password that's used
> to login with?
No (deliberately so).
> If I add "hostall user172.17.32.0 255.255.255.0
> password"
> to pg_hba.conf the user can login with a blank password.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 8 Dec 2004, FM wrote:
I'm using RPM from postgresql site (v 7.4.1). I need to add krb5 auth so I
need to recompile SRPMS. I cannot find it in the source tree.
Is there a place where we can find the SRPM ?
ftp://ftp6.tr.PostgreSQL.org/postg
Itamar Reis Peixoto+55 34 3238 3845+55 38
9107 1250http://www.ispbrasil.com.br
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.0 - Release Date: 9/12/2004
---(end of broadcast)---
TIP
John Jensen wrote:
Hi Greg & others.
I run this on a 4 cpu smp box (Dell PE6650+EMC AX100) so I already
offload pg_dump, gzip and split to other cpu's. Top confirms this:
postmaster = 95% cpu ie. it uses one cpu completely. Unless I can get
postmaster to do less work (that's what I'm looking for) o
On Wed, Dec 08, 2004 at 08:08:07AM -0500, Chuming Chen wrote:
> Is there any way I can find the correspondence between the numbered
> folders under postgresql data/base and the actual database name or table
> name?
You could use contrib/oid2name. If you want to do it yourself,
look at the pg_
26 matches
Mail list logo
