[GENERAL] Re: FATAL: no pg_hba.conf entry for host “::1”

2012-07-25 Thread saleem
Go to the server where you are trying to connect, open the file "pg_hba.conf" and add the IP of the machine that you are using to connect to .. i hope this post helps -- View this message in context: http://postgresql.1045698.n5.nabble.com/FATAL-no-pg-hba-conf-entry-for-host-1-tp1873063p57180

[GENERAL] Run procedure at startup

2009-07-27 Thread Saleem EDAH-TALLY
Hello, Is there a way to run a pl/pgsql automatically at server startup ? Is there a way to run a pl/pgsql function with an infinite loop as a daemon ? Is there a way to start a pl/pgsql function that would persist after the user session has closed ? Is there a way for an unprivileged user to

[GENERAL] postgresql.key secure storage

2009-09-13 Thread Saleem EDAH-TALLY
Hello, This concerns use of postgresql.key private key file on the client side. psql can't establish a connection. with an encrypted postgresql.key file. If I'm wrong here, the following is invalid and please show me the steps I'm ignoring. An application using libpq would require that the pri

Re: [GENERAL] postgresql.key secure storage

2009-09-13 Thread Saleem EDAH-TALLY
>A user must have the TRUNCATE privilege to truncate a table or be the >tables owner. Well the TRUNCATE example I mentioned is perhaps not explicit of what I meant to say. A user who can modify data in a client application can also modify data if he connects directly to the database, bypassing t

Re: [GENERAL] postgresql.key secure storage

2009-09-14 Thread Saleem Edah-Tally
>a separate application server Well this can be a solution in a trustworthy and friendly environment, on which I can't count. I would have been more at ease if libpq could manage a PKCS12 cert. or some secure wallet/keystore that contains both the public and private keys for SSL traffic. Neith

Re: [GENERAL] postgresql.key secure storage

2009-09-14 Thread Saleem Edah-Tally
>a separate application server Well this can be a solution in a trustworthy and friendly environment, on which I can't count. I would have been more at ease if libpq could manage a PKCS12 cert. or some secure wallet/keystore that contains both the public and private keys for SSL traffic. Neith

Re: [GENERAL] postgresql.key secure storage

2009-09-14 Thread Saleem EDAH-TALLY
Le Monday 14 September 2009 16:13:45, vous avez écrit : > "Secure > wallet" is an exercise in self-delusion. Not really. How can a user extract data from a container, by whatever name we call it, if he does not have the key to open it ? Could you please instruct how to achieve this ? -- Sent

Re: [GENERAL] postgresql.key secure storage

2009-09-14 Thread Saleem EDAH-TALLY
OK guys, I would never have thought about modifying libpq to steal confidential data, and I have never used debuggers in this respect at all. So super gurus can yet do the bad thing. Nevertheless 99% of users are not super gurus who could do such nasty things but a few of them could use an une