Re: [GENERAL] /usr/sbin/useradd is needed by postgresql-server-8.0.1-PGDG

Hi, Citing Rey Arqueza <[EMAIL PROTECTED]>: > after running: rpm -i ./postgresql-server-8.0.1-1PGDG.i686.rpm, I get the > following error: > > error: Failed dependencies: > /usr/sbin/useradd is needed by postgresql-server-8.0.1-PGDG > > I would guess that /usr/sbin needs to be in my path? if I

[GENERAL] Howto cite postgresql in scientific publications?

Hi, Is there an official way to cite PostgreSQL in scientific publications? This might sound somewhat strange to some of you, but e.g. the R project (http://www.r-project.org, open source environment for statistical computing as a side note) has a FAQ entry like this: 2.8 Citing R To cite R in

Re: [GENERAL] Statically linking against libpq

Hi, Looks to me like you have to add -lkrb5 and -lssl to your compile flags as well. Perhaps some more others (you can use nm in conjunction with grep to find which libraries define the missing symbols (On OpenBSD like so: 'cd /usr/lib && nm -o * | grep krb5_free_context' but that might differ on

Re: [GENERAL] handing created and updated fields

Hi, Citing "Jim C. Nasby" <[EMAIL PROTECTED]>: > ON INSERT: force created and updated to be current_timestamp > ON UPDATE: deny updated created. force updated to be set to > current_timestamp [snip] > Does anyone have an example of the best way to handle this scenario? Something along the lines o

Re: [GENERAL] Connect to Postgres 7.4 via ODBC

Hi, Citing Nadia Kunkov <[EMAIL PROTECTED]>: > Locally I have no problems connecting to the database and running psql. > I need to set up an ODBC connection from my Windows box. > Here is what I've done: > > 1.In postgresql.conf > tcpip_socket = true > (By the way does this eli

Re: [GENERAL] When to encrypt

Hi, Citing Greg Stark <[EMAIL PROTECTED]>: > Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > > Actually, hard disk encryption is useful for one thing: so if somebody > > kills the power and takes the hard disk/computer, the data is safe. > > While it's running it's vulnerable though... > > W

Re: [GENERAL] When to encrypt

Hi, Citing Derek Fountain <[EMAIL PROTECTED]>: > Indeed, but I'm still interested in the general answer. There is no general answer. Depends on how deep you get into trouble, if the data is compromised. > The server I have been looking at was hopelessly insecure and SQL > injection is only one o

Re: [GENERAL] change natural column order

Hi, Joolz, you already got quite a few answers, that the frontend is probably not properly designed, if it relies on a certain column ordering. I agree completely with that. However your question got me curious, and I've digged around a bit in the system tables. You might be interested in my findi

Re: [GENERAL] rules

Hi, Citing Jamie Deppeler <[EMAIL PROTECTED]>: > sample sql querty > > INSERT INTO schema.table2 > ( > "field1", > "field2", > "field3", > "field4", > "field5", > "field6", > "field7", > "field8", > "field9", > ) > VALUES > ( > SELECT >

Re: [GENERAL] why use SCHEMA? any real-world examples?

Hi, Citing Miles Keaton <[EMAIL PROTECTED]>: > I just noticed PostgreSQL's schemas for my first time. > (http://www.postgresql.org/docs/current/static/ddl-schemas.html) > > I Googled around, but couldn't find any articles describing WHY or > WHEN to use schemas in database design. When your dat

Re: [GENERAL] postgres "on in the internet"

Hi, Citing Paul Tillotson <[EMAIL PROTECTED]>: > At my company we are looking at deploying clients for our client/server > app outside our firewall, which will then require our postgres box to be > internet-accessible. > > Does anyone out there have experience with this or

Re: [GENERAL] pg_dump in stand alone backend

Hi, Citing Ulrich Wisser <[EMAIL PROTECTED]>: > I would like to stop the postmaster every night and run > > vacuum > pg_dump > reindex > > in the stand alone backend. > > Vacuum and reindex seem to be quite easy, as I can setup a small script > with both commands. But what about pg_dump. That

Re: libpq: passwords WAS: [GENERAL] scripting & psql issues

Hi Tom, Thanks a lot, that was the kind of clarification I needed. On Fri, Aug 20, 2004 at 10:32:59AM -0400, Tom Lane wrote: > Daniel Martini <[EMAIL PROTECTED]> writes: > > No he can't: > > Only if he is able to install a program on the webserver to > > actually

Re: libpq: passwords WAS: [GENERAL] scripting & psql issues

Hi, Citing Tom Lane <[EMAIL PROTECTED]>: > Daniel Martini <[EMAIL PROTECTED]> writes: > > Now how would this work, if it would be possible to send hashed passwords > > from libpq: > > user sends username/password, this gets hashed by the cgi, then the hashed >

Re: [GENERAL] Pass parameters to SQL script

Hi, Citing Fuchs Clemens <[EMAIL PROTECTED]>: > is it possible to pass parameters to a SQL script, which I launch via the > psql shell? yes > In Oracle it works like that: > > sqlplus myscript.sql myschema > > and within the script I can use the parameter like this: > > CONC