Re: [GENERAL] Performance critical technical key

2004-08-12 Thread Pierre-Frédéric Caillaud
You could use apache mod_auth_tkt : http://www.openfusion.com.au/labs/mod_auth_tkt/ Its main advantage is that it'll authentify a user, hence your script gets the user ID, which you can use as a key in your session table for instance. Cut & paste for the lazies : mod_auth_tkt is a lig

Re: [GENERAL] pg_dump in windows postgres 8.0

2004-08-12 Thread Mike G
Hi, I don't think you can. I logged it as a bug a few days ago. You might be able to create the tables and execute the copy command to fill them with pgadminIII. Mike On Thu, Aug 12, 2004 at 09:29:21AM -0500, Jason Tesser wrote: > I just downloaded the new beta for windows. I usually only use

Re: [GENERAL] PostgreSQL 8.0 Feature List?

2004-08-12 Thread Richard Welty
On Thu, 12 Aug 2004 14:36:13 -0400 Vivek Khera <[EMAIL PROTECTED]> wrote: > > "RW" == Richard Welty <[EMAIL PROTECTED]> writes: > RW> i'm quite experienced in C and Java, so it's going to be in one of > RW> those two. any comments from anyone on the language choice? > eRServer is written in J

Re: [GENERAL] Replication options?

2004-08-12 Thread Liam Lesboch
Thank you for your overviews and responses. Much appreciation. Where might one find reviews or testimonials of your product and priceing? Liam From: "Joshua D. Drake" <[EMAIL PROTECTED]> To: Jan Wieck <[EMAIL PROTECTED]> CC: Liam Lesboch <[EMAIL PROTECTED]>,[EMAIL PROTECTED] Subject: Re: [GENERA

Re: [GENERAL] Performance critical technical key

2004-08-12 Thread Geoff Caplan
Bruno Wolff III wrote: >>> Using a sequence shouldn't be slow. Thanks - that's the main thing I need to know. >>> The main potential problem is that it will make the session IDs >>> guessible if you don't take any other steps. That may or may not >>> be a problem. Thanks for the warning, but I

Re: [GENERAL] Resultset problem or BUG !

2004-08-12 Thread Kris Jurka
On Wed, 11 Aug 2004, Elie Nacache wrote: > A data writed in a table but not commited is not accessible in > modification by the resultset. The error returned is "Cannot move to > index of 0". > It is entirely unclear what you are actually doing here. Are you using JDBC? Could you show us

Re: [GENERAL] Strange pg_hba.conf error (repost)

2004-08-12 Thread Arthur van Dorp
The postgresql book by wrox tells us to create a user postgres using "useradd" command but when I look into User & groups using RH9.1 configuration tool I dont see any such users but the corresponding "useradd postgres" fails. Little confusing...damn my intelligence... Have a look at the file /etc/

Re: [GENERAL] Clustering, mirroriing, or replication?

2004-08-12 Thread Jon Brisbin
At each store, there are a number of POS registers that are networked. If they enter a ticket at one register, they should be able to go to any other register to tender the transaction, etc... We already have mechanisms in place to remotely download and install software on existing PCs, so no add

Re: [GENERAL] pg_restore with Fc fails with [archiver] out of

2004-08-12 Thread Sven Willenberger
On Tue, 2004-08-10 at 19:28 -0400, Sven Willenberger wrote: > > Tom Lane wrote: > > Sven Willenberger <[EMAIL PROTECTED]> writes: > > > >>pg_restore in malloc(): error: allocation failed > >>Abort (core dumped) > > > > > > A stack trace from that core file would be useful in figuring out what >

Re: [GENERAL] Replication options?

2004-08-12 Thread Joshua D. Drake
> As far as I know (Joshua please clearify here) Mammoth Replicator writes its own, binary journal containing the changes that need to be applied to the replica. Yes that is correct. On a first look inserting into database tables might look more expensive. But there are some fine details that

Re: [GENERAL] Strange pg_hba.conf error (repost)

2004-08-12 Thread Karam Chand
Well from: http://www.postgresql.org/docs/7.3/static/client-authentication.html local This record matches connection attempts using Unix domain sockets. Without a record of this type, Unix-domain socket connections are disallowed Since I am connecting from my linux box, it might be the problem

Re: [GENERAL] PostgreSQL 8.0 Feature List?

2004-08-12 Thread Marc G. Fournier
On Thu, 12 Aug 2004, Vivek Khera wrote: "RW" == Richard Welty <[EMAIL PROTECTED]> writes: RW> i'm quite experienced in C and Java, so it's going to be in one of RW> those two. any comments from anyone on the language choice? eRServer is written in Java. It sucks up about 200Mb+ virtual memory for

[GENERAL] datpath error

2004-08-12 Thread Raymond O'Donnell
Hello all, I've installed the new Win32 version of 8.0-beta1, running as a service. When I connect to it using pgAdmin III and attempt to list databases, I get an error: 'Column "datpath" does not exist.' I got the same error reported when starting postmaster from the command line using pg_ctl

[GENERAL] Access restrictions on rows depending on value of the a column

2004-08-12 Thread Renato Cramer
Hello All, There is data of several enterprises (ours clients) in a single database. All tables have a column on primary key what identify the enterprise called id_enterprise. My objective is restrict users access on rows depending on value of the column id_enterprise. That is, an user can access

[GENERAL] Performance critical technical key

2004-08-12 Thread Geoff Caplan
Hi folks I'm designing a table to be used for web session management. If all goes well with the project, the table should have 100,000+ records and be getting hammered with SELECTS, INSERTS and UPDATES. The table will need a technical key. The question is, what is the most efficient way to do thi

Re: [GENERAL] history tables with only one function?

2004-08-12 Thread Raphael Bauduin
Andreas Haumer wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! Raphael Bauduin wrote: Raphael Bauduin wrote: Hi, I'm looking at the logging of a database we'll put in production soon. I've seen some posts on this list about history tables, like mentioned in http://www-106.ibm.com/develope

[GENERAL] PgSQL 8.0.0 beta1 compile problem + patch

2004-08-12 Thread Nikola Milutinovic
Hi all. Ran into a minor showstopper. Sometimes, my CC is just too much of a nitpick, but on this matter, I agree with it. "./src/timezone/zic.c" has a mismatch in declaration and definition of "memcheck(...)" function. My CC beltched on it (I was running it in strict ANSI mode). The diference

Re: [GENERAL] Replication options?

2004-08-12 Thread Andrew Sullivan
I'll try this again, since it doesn't seem to have made it to the list. On Wed, Aug 11, 2004 at 12:02:07PM -0400, Tom Lane wrote: > Now erServer did work for them, but it required significant amounts of > tuning and constant babysitting by the DBA. (If Andrew Sullivan is > paying attention to th

Re: [GENERAL] Clustering, mirroriing, or replication?

2004-08-12 Thread Richard Huxton
Jon Brisbin wrote: We're trying to figure out how we can implement a reasonably simple cluster of postgres servers on a private network at our store locations. The idea is to have a group of 2-6 PCs each be able to share data in a replicated manner. Having a separate database server is not an opt

Re: [GENERAL] How to identify which query is running - reg.

2004-08-12 Thread Richard Huxton
Shanmugasundaram Doraisamy wrote: Dear Richard, Thankyou for you immediate reply, I did set the stats_command_string=true and tried select * from pg_stat_activity; It gave me the desired result. In the mean while you had mentioned about reading the monitoring activity ch

Re: [pgsql-hackers-win32] [GENERAL] error moving table to tablespace

2004-08-12 Thread Andreas Pflug
Tom Lane wrote: Christian Traber <[EMAIL PROTECTED]> writes: Maybe its only win32 version? Well, I can't reproduce it on Unix. It seems awfully odd though that you can create tables in that tablespace to begin with but can't move them there. I'm cc'ing this to the pgsql-hackers-win32 to see if a

Re: [GENERAL] disabling autocommit

2004-08-12 Thread Michael Kleiser
I had postet a similar question some time ago. Someone answerded me, in the next PostgreSQL it would be possible to use nested transactions. Is is now implemented in version 8.0-beta You can set a savepoint before the insert that possible fails. http://developer.postgresql.org/docs/postgres/sql-sa