>> I am looking for a tool in the PostgreSQL database that can help to audit
>> fraudulent activities on a PostgreSQL database. Of particular interest is
>> how to retrieve say from a PostgreSQL sales database all the deleted rows.
>>
>
> you can use triggers
>
> PostgreSQL has no other internal
[…]
---> Installing postgresql90-server @9.0.5_0
To create a database instance, after install do
sudo mkdir -p /opt/local/var/db/postgresql90/defaultdb
sudo chown postgres:postgres /opt/local/var/db/postgresql90/defaultdb
sudo su postgres -c '/op
On 10/23/2011 07:16 PM, René Fournier wrote:
[…]
---> Installing postgresql90-server @9.0.5_0
To create a database instance, after install do
sudo mkdir -p /opt/local/var/db/postgresql90/defaultdb
sudo chown postgres:postgres /opt/local/var/db/postgres
By default the postgres user's group is 'daemon' on my Mac. This is
probably true for you as well. Change occurrences of
'postgres:postgres' in your chown commands to 'postgres:daemon'.
On 10/23/2011 8:16 PM, René Fournier wrote:
[…]
---> Installing postgresql90-server @9.0
Hello,
I am using Postgresql 8.3, I am getting the below authentication
exceptions. I am not able to connect using
postgres://mpp:mpp@localhost/mpp
LOG: provided username (mpp) and authenticated username
([U2FsdGVkX1/4XrEZ3dfREbh66kqWj66oEZjvotlVtqo=]) don't match
FATAL: Ident authentication f
On 10/23/11 9:08 PM, Prakash, Deepthi (NSN - IN/Bangalore) wrote:
Hello,
I am using Postgresql 8.3, I am getting the
belowauthenticationexceptions.I am not able to connect
usingpostgres://mpp:mpp@localhost/mpp
.
hostall all 127.0.0.1/32 ident
# IPv6 local
Yes authd is running.
And I am using 8.4 version. Sorry for the wrong version below.
Thanks and Regards,
Deepthi
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of ext John R
Pierce
Sent: Monday, October 24, 2011 10:05 AM
Yes authd is running.
And I am using 8.4 version. Sorry for the wrong version below.
Thanks and Regards,
Deepthi
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of ext John R
Pierce
Sent: Monday, October 24, 2011 10:05 AM
I was trying to enable ldap authentication for 9.1 server.
I did:
./configure --with-ldap --with-openssl
make
sudo make install
And got these files installed:
ll /usr/local/pgsql/bin/
-rwxr-xr-x 1 root root 54811 Oct 24 10:27 clusterdb
-rwxr-xr-x 1 root root 55860 Oct 24 10:27 createdb
-
