[ADMIN] RE: [SQL] Apache authentication & PostgreSQL

1999-06-10 Thread Volker Hess
On 11-Jun-99 Fomichev Michael wrote: > Hi, all ! > I'm trying to show data from the PostgreSQL database to the Web page, > using WWW-SQL. I want the users to get an access to the database from the > browsers under their own names. To achieve this I configured Apache so > that it would authenticat

[ADMIN] Re: [SQL] Apache authentication & PostgreSQL

1999-06-10 Thread Remigiusz Sokolowski
> Hi, all ! > I'm trying to show data from the PostgreSQL database to the Web page, > using WWW-SQL. I want the users to get an access to the database from the > browsers under their own names. To achieve this I configured Apache so > that it would authenticate an user when the user enters the dir

[ADMIN] Apache authentication & PostgreSQL

1999-06-10 Thread Fomichev Michael
Hi, all ! I'm trying to show data from the PostgreSQL database to the Web page, using WWW-SQL. I want the users to get an access to the database from the browsers under their own names. To achieve this I configured Apache so that it would authenticate an user when the user enters the directory wit

[ADMIN] pgsql: "reseting connection" msg. (fwd)

1999-06-10 Thread Bob Parkinson
Dear All, I'm getting this msg. out of postgres 6.4.2 when trying to do a copy as a normal user. The cmd. is run from a perl script thusly: `psql -d omni_core -c \"copy template from stdin using delimiters '|'\" < $tname`; What does this msg. imply? (Been through some of the archive and not se

Re: [ADMIN] How to replicate databases?

1999-06-10 Thread Peter Galbavy
It would be interesting to find out if this works well enough. One piece of simplistic advice though, from someone who has been there with another distributed RADIUS system - make sure your master server is used only for updates and maintenance queries - do NOT EVER use it for "customer facing" q

Re: [ADMIN] How to replicate databases?

1999-06-10 Thread John Reynolds
Uggh, A bit of speculation on my behalf, You could run the master database postmaster with a -d option with the output redirected to a file, here's mine from my rc.x file (linux) su database -c '/usr/pgsql/bin/postmaster -i -D /usr/pgsql/data -d 2 >& /tmp/database.log &' I use to check what m

[ADMIN] Installing PostgreSQL6.4.2.: createdb and ipc/semctl-bug(?)

1999-06-10 Thread Jelle Ruttenberg
Hi all, I'm trying to install PostgreSQL 6.4.2., and all went well -including initdb- until I typed createdb. This resulted in a known error concerning ipc/semctl. Although this problem has been posted earlier to the lists, I haven't seen an answer yet. Maybe someone has found a solution? Th

Re: [ADMIN] Encrypted connections to Postgres

1999-06-10 Thread Jan Wieck
> > I'm talking with the boss about Postgres and the conversation turned to > security. What kind of security features does Postgres have? I'm aware of the > host-based authentication in pg_hba.conf. Are the actual connections to the > database (SQL queries and what they return) encrypted? Th

[ADMIN] Encrypted connections to Postgres

1999-06-10 Thread Brian Baquiran
I'm talking with the boss about Postgres and the conversation turned to security. What kind of security features does Postgres have? I'm aware of the host-based authentication in pg_hba.conf. Are the actual connections to the database (SQL queries and what they return) encrypted? Thanks, Brian --