[ADMIN] Error Code

Dear Milist;   My Application is Developed by Delphi with Ms-SQL Server as a previous Database and we are using ODBC/BDE (Borland Database Engine) for Database connection. And We've been porting the database to PostgreSQL. So far so Good.   And now our problem is How do we get The Error

[ADMIN] pg_hba, access control for a webserver, superuser, and joe user

I am running a system with three types of users: A) Joe User, who may have a pg database I don't care if Joe User, once logged in to the system has to type a password or not to get access to his db local sameuser md5 or local all ident sameuser

Re: [ADMIN] Replication

On Tue, 2003-01-28 at 11:01, Marc G. Fournier wrote: > On Tue, 28 Jan 2003, Will LaShell wrote: > > > Hrmm, this is kind of sad. rserv actually does work pretty well. We use > > it in a production environment here at OFS on a medium size database > > cluster. > > I think you are the first person

Re: [ADMIN] Replication

On Tue, 2003-01-28 at 14:12, Andrew Sullivan wrote: > On Tue, Jan 28, 2003 at 09:59:52AM -0700, Will LaShell wrote: > > What problems have people been having getting rserv to work at all? > > In 2001 I tested it for our anticipated load. It worked for me, but > it was not up to the kind of load t

Re: [ADMIN] Replication

On Tue, 28 Jan 2003, Will LaShell wrote: > > The biggest one I've heard: documentation sucks > > This truely is an issue, the documentation can be painful, however in > reality there is very little to do with it. Run the master / slave setup > add the tables, and run the replicate. I think perha

Re: [ADMIN] Cannot connect to the database (PG 7.3)

OK, (putting on best Ed McMahon voice), "you are correct, sir." That's what I get for keeping those old versions around. But... 7.2.3 psql -> 7.2.3 server = OK 7.3.1 psql -> 7.2.3 server = OK 7.3.1 psql -> 7.3.1 server = broken 7.2.3 psql -> 7.3.1 server = broken So, looks like it's in the backe

Re: [ADMIN] Cannot connect to the database (PG 7.3)

Steve Crawford <[EMAIL PROTECTED]> writes: > Hmmm, I tried it (7.3.1) and it seems to work fine. > steve@betelgeuse:~> psql -h betelgeuse -U 12345 steve > Welcome to psql, the PostgreSQL interactive terminal. That's not 7.3 ... or at least not a 7.3 psql. It would show its version number if it w

Re: [ADMIN] Replication

On Tue, 2003-01-28 at 12:42, Fabian Peters wrote: > Hi folks! > > Is anybody using pgReplicator? > > I've read through the documentation but haven't tried it yet. I'm looking > for a solution that can offer asynchronous, update-anywhere replication. > Confli

Re: [ADMIN] Cannot connect to the database (PG 7.3)

Hmmm, I tried it (7.3.1) and it seems to work fine. Perhaps something else is going on - pg_hba.conf setup??: steve=# create user "12345"; CREATE USER steve@betelgeuse:~> psql -h betelgeuse -U 12345 steve Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution t

Re: [ADMIN] Cannot connect to the database (PG 7.3)

Michiel Lange <[EMAIL PROTECTED]> writes: > It is, somehow, not possible to connect as a user which name is completely > numeric. I muttered "nonsense!" to myself, but darned if you're not right: regression=# create user "12345"; CREATE USER regression=# \q $ psql -U 12345 regression psql: FATAL

Re: [ADMIN] Cannot connect to the database (PG 7.3)

OK, I figured it out now: It is, somehow, not possible to connect as a user which name is completely numeric. I did a few tests on the same machine, and this is the outcome: psql -h myhost -d mydb -U postgres -> connects fine CREATE USER "12345" WITH PASSWORD 'secret'; CREATE USER \q psql -h myh

Re: [ADMIN] Replication

Hi folks! Is anybody using pgReplicator? I've read through the documentation but haven't tried it yet. I'm looking for a solution that can offer asynchronous, update-anywhere replication. Conflict resolution is not an issue. It seems that pgReplicator would

[ADMIN] Problem with BYTEA data types restoring dumped data from another postgres database

Title: Message I'm having the next problem with the BYTEA field types, when I try to restore data into a new database from another postgres database (same version, 7.2).   ERROR:  Invalid UNICODE character sequence found (0xed5c30) pg_restore: [archiver (db)] could not execute query: ERROR: 

Re: [ADMIN] restricting identd to just the loopback adapter.

On Sun, Jan 26, 2003 at 09:48:33PM -0800, Jerry Asher wrote: > I installed pidentd from the red hat 8.0 distribution and started it > up but, but looking over the conf files, there is apparently no way to > restrict identd to listening/binding only to the localhost adapter. The sgi_fam service con

Re: [ADMIN] restricting identd to just the loopback adapter.

David Jericho wrote: On Sun, Jan 26, 2003 at 09:48:33PM -0800, Jerry Asher wrote: >I installed pidentd from the red hat 8.0 distribution and started it >up but, but looking over the conf files, there is apparently no way to >restrict identd to listening/binding only to the localhost adapter. T

Re: [ADMIN] New User - Please Help

Michael Cupp wrote: I know this is extremely remedial and trival for most of you - but I am a very new user, and need to know what I have to do to get my database instance created? Anyone that has a cheatsheet or something they can send me would also be greatly appreciated. I am a 10+ year

Re: [ADMIN] Replication

On Tue, 28 Jan 2003, Will LaShell wrote: > Hrmm, this is kind of sad. rserv actually does work pretty well. We use > it in a production environment here at OFS on a medium size database > cluster. I think you are the first person taht I've seen that has admit'd to using it ... other then a few 'b

Re: [ADMIN] Replication

On Mon, 2003-01-27 at 21:10, Marc G. Fournier wrote: > On Mon, 27 Jan 2003, Andrew Sullivan wrote: > > > On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote: > > > > > > the eRServer is for free or not ? > > > > "Not", as far as I know. Its baby cousin is in contrib/rserv in the > > s

Re: [ADMIN] restricting identd to just the loopback adapter.

On Sun, Jan 26, 2003 at 21:48:33 -0800, Jerry Asher <[EMAIL PROTECTED]> wrote: > I have installed running pg 7.2, and it apparently would like to have > an identd server to help it establish who is who. First off, are the users logging into the same machine that the database server is running on

Re: [ADMIN] New User - Please Help

Michael- This document should get you started: http://www.postgresql.org/idocs/index.php?tutorial.html look at section 1.3 in particular. -Nick > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Michael Cupp > Sent: Monday, January 27, 2003 11:33 AM

Re: [ADMIN] Index Scan Backward

At 10.17 27/01/2003 -0500, you wrote: > Limit (cost=0.00..1003.36 rows=1 width=454) (actual time=806.78..2097.61 > rows=1 loops=1) > -> Nested Loop (cost=0.00..392651.18 rows=391 width=454) (actual > time=806.77..2097.59 rows=2 loops=1) > -> Index Scan Backward using forum_pos