Here is what mine looks like on Ubuntu 12.0.4
# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all postgres trust
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
On 02/05/2013 08:20 AM, Johan Hendriks wrote:
I get the following
$ psql -U baruwa baruwa
psql: FATAL: no pg_hba.conf entry for host "[local]", user "baruwa",
database "baruwa", SSL off
my pg_hba.conf looks like this
# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all pgsql trust
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
# end
BTW the baruwa2 gui works.
I installed phppgadmin, it it tells me the database is populated.
Also i get the following in my /var/log/messages
Feb 5 15:19:51 baruwa2 mailscanner: Process did not exit cleanly,
returned 255 with signal 0
Feb 5 15:19:51 baruwa2 postgres[56585]: [2-1] ERROR: relation
"msrulesets" does not exist at character 41
Feb 5 15:19:51 baruwa2 postgres[56585]: [2-2] STATEMENT: SELECT
row_number, ruleset AS rule FROM msrulesets WHERE name=$1
Feb 5 15:19:51 baruwa2 mailscanner: Process did not exit cleanly,
returned 255 with signal 0
Feb 5 15:19:51 baruwa2 postgres[56587]: [2-1] ERROR: relation
"msrulesets" does not exist at character 41
Feb 5 15:19:51 baruwa2 postgres[56587]: [2-2] STATEMENT: SELECT
row_number, ruleset AS rule FROM msrulesets WHERE name=$1
Feb 5 15:19:56 baruwa2 mailscanner: Process did not exit cleanly,
returned 255 with signal 0
Feb 5 15:19:56 baruwa2 postgres[56589]: [2-1] ERROR: relation
"msrulesets" does not exist at character 41
Feb 5 15:19:56 baruwa2 postgres[56589]: [2-2] STATEMENT: SELECT
row_number, ruleset AS rule FROM msrulesets WHERE name=$1
Feb 5 15:19:56 baruwa2 mailscanner: Process did not exit cleanly,
returned 255 with signal 0
Feb 5 15:19:56 baruwa2 postgres[56591]: [2-1] ERROR: relation
"msrulesets" does not exist at character 41
Feb 5 15:19:56 baruwa2 postgres[56591]: [2-2] STATEMENT: SELECT
row_number, ruleset AS rule FROM msrulesets WHERE name=$1
Feb 5 15:20:01 baruwa2 mailscanner: Process did not exit cleanly,
returned 255 with signal 0
Feb 5 15:20:01 baruwa2 mailscanner: Process did not exit cleanly,
returned 255 with signal 0
Feb 5 15:20:01 baruwa2 postgres[56598]: [2-1] ERROR: relation
"msrulesets" does not exist at character 41
Feb 5 15:20:01 baruwa2 postgres[56598]: [2-2] STATEMENT: SELECT
row_number, ruleset AS rule FROM msrulesets WHERE name=$1
Feb 5 15:20:01 baruwa2 postgres[56600]: [2-1] ERROR: relation
"msrulesets" does not exist at character 41
Feb 5 15:20:01 baruwa2 postgres[56600]: [2-2] STATEMENT: SELECT
row_number, ruleset AS rule FROM msrulesets WHERE name=$1
gr
Johan
Andrew Colin Kissa schreef:
On 05 Feb 2013, at 3:45 PM, Johan Hendriks wrote:
So i geus it is, but i have never used postgresql.
So what is the fastest way to check?
psql -U baruwa baruwa
=>\dv
--
www.baruwa.org
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
