Re: [ADMIN] postgres authentication

2007-08-07 Thread Tom Lane
"Tena Sakai" <[EMAIL PROTECTED]> writes: > and added the following line to pg_hba.conf file: > hostall donder ldap://amarula.egcrc.orgsent I know nothing about ldap, but this is clearly not a correct host line: you forgot the address field(s), and that last bit should be an op

Re: [ADMIN] PITR backup to Novell Netware file server

2007-08-07 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > Apparently we will be moving to a Linux-based implementation of Netware at > some unspecified future date, at which point we will apparently be able to > deal directly with the Linux layer. At that point, there are obvious, clean > solutions; but w

Re: [ADMIN] PITR backup to Novell Netware file server

2007-08-07 Thread Andrew Kroeger
Kevin Grittner wrote: > The Netware server supports ssh, scp, and an rsync daemon. I don't see how > the ssh implementation is helpful, though, since it just gets you to the > Netware console -- you can't cat to a disk file through it, for example. > (At least not as far as we have been able to se

Re: [ADMIN] ssl and odbc standar driver

2007-08-07 Thread Andreas
In deed it is possible. You'll need a ssl certificate and a private key and put it on c: in your users \application data\postgresql directory. You'll have to create the postgresql-directory first. The certificate has to be namedpostgresql.crt and the key postgresql.key. Now you can

[ADMIN] postgres authentication

2007-08-07 Thread Tena Sakai
Hi everybody, I am having a problem with crating user. It has to do with authentication. What I want is to authenticate a user via an ldap server. I created postgres account by: create user donder with createdb login in group analysis; and added the followi

Re: [ADMIN] PITR backup to Novell Netware file server

2007-08-07 Thread Kevin Grittner
> >>> Decibel! <[EMAIL PROTECTED]> 08/07/07 4:51 PM >>> > On Tue, Aug 07, 2007 at 02:12:29PM -0500, Kevin Grittner wrote: > > > Copying a 16MB file that's already in memory isn't exactly an intensive > > > operation... > > > > That's true for the WAL files. The base backups are another story.

[ADMIN] ssl and odbc standar driver

2007-08-07 Thread Fabricio PeƱuelas
Hi!! It is possible to connect to postgres with odbc standar driver and ssl enabled ?? Es posible conectarme a postgresql con odbc standar driver y ssl activado? thanks!!! _ El mejor destino, con los mejores contenidos http://w

[ADMIN] Help with High value unicode characters

2007-08-07 Thread Chris Hoover
We need some help, we have some what we believe are high value unicode characters (Unicode 0x2). How can you search and replace for these? We are storing this data in a text field, and having the data contain this unicode value is violating our xml rules the application uses and causing abends in

Re: [ADMIN] PITR backup to Novell Netware file server

2007-08-07 Thread Decibel!
On Tue, Aug 07, 2007 at 02:12:29PM -0500, Kevin Grittner wrote: > > 2) Have archive_command copy to someplace on the database server, and > > have another process copy from there to both the local backup as well as > > the central backup. > > A possible option; although if the rsync daemon on the

[ADMIN] Transaction-Override

2007-08-07 Thread Martin Fandel
Hi, i've a problem with my postgresql database (v8.1.5-13 on opensuse 10.2). The database transaction limit is running over and postgres does a restart. I do daily a "vacuum verbose analyze" over the hole database. So what I'm doing wrong? The db has restarted itself to prevent a transaction-ov

Re: [ADMIN] PITR backup to Novell Netware file server

2007-08-07 Thread Kevin Grittner
> >>> Decibel! <[EMAIL PROTECTED]> 08/07/07 1:28 PM >>> > On Tue, Aug 07, 2007 at 06:29:35AM -0500, Kevin Grittner wrote: >> We have a database in each Wisconsin county which is part of the official >> court record for the circuit courts in that county. We are required to keep >> a backup in each

Re: [ADMIN] Transaction-Overflow

2007-08-07 Thread Tom Lane
[EMAIL PROTECTED] writes: > On the top in the log file is this, do you know why the pid is killed with = > 11? I'm a little bit confused :(. > LOG: Serverprozess (PID 30399) wurde von Signal 11 beendet SIG 11 (ie SIGSEGV) is pretty much the typical "generic crash" indication. It most likely me

Re: [ADMIN] Transaction-Overflow

2007-08-07 Thread Decibel!
On Tue, Aug 07, 2007 at 05:34:53PM +0200, [EMAIL PROTECTED] wrote: > On the top in the log file is this, do you know why the pid is killed with > 11? I'm a little bit confused :(. > > LOG: Serverprozess (PID 30399) wurde von Signal 11 beendet That means that a backend was killed with a signal

Re: [ADMIN] PITR backup to Novell Netware file server

2007-08-07 Thread Decibel!
On Tue, Aug 07, 2007 at 06:29:35AM -0500, Kevin Grittner wrote: > We have a database in each Wisconsin county which is part of the official > court record for the circuit courts in that county. We are required to keep > a backup in each county, such that we could recover a lost or corrupted > data

Re: [ADMIN] PITR with rsync

2007-08-07 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Tom Lane wrote: >> well, I was using rysnc so I could copy to a different computer over >> ssh, not using the rsync protocol to catch diffs. I don't have a >> remote file system mounted so I can do just a cp. > If you are going over an ssh conn

Re: [ADMIN] PITR with rsync

2007-08-07 Thread Steve Crawford
> If you are going over an ssh connection then scp seems like the > appropriate tool. Yeah, rsync would work, but it's just a useless > extra layer of software... Actually, rsync has one edge over scp even where its other attributes are moot: atomicity. Rsync keeps the data in a temporary locati

Re: [ADMIN] Transaction-Overflow

2007-08-07 Thread pingu . freak
Hi Tom, thank you for the very fast answer! On the top in the log file is this, do you know why the pid is killed with 11? I'm a little bit confused :(. LOG: Serverprozess (PID 30399) wurde von Signal 11 beendet LOG: aktive Serverprozesse werden abgebrochen WARNUNG: breche Verbindung ab w

Re: [ADMIN] Transaction-Overflow

2007-08-07 Thread Tom Lane
[EMAIL PROTECTED] writes: > i've a problem with my postgresql database (v8.1.5-13 on opensuse 10.2). Th= > e database transaction > limit is running over and postgres does a restart. I don't read German well, but as far as I can see there is nothing in what you posted that suggests a transaction w

[ADMIN] Transaction-Overflow

2007-08-07 Thread pingu . freak
Hi, i've a problem with my postgresql database (v8.1.5-13 on opensuse 10.2). The database transaction limit is running over and postgres does a restart. I do daily a "vacuum verbose analyze" over the hole database. So what I'm doing wrong? The db has restarted itself to prevent a transaction-ove

[ADMIN] PITR backup to Novell Netware file server

2007-08-07 Thread Kevin Grittner
We have a database in each Wisconsin county which is part of the official court record for the circuit courts in that county. We are required to keep a backup in each county, such that we could recover a lost or corrupted database with what is in the county (as well as keeping at least four separa