2014-03-03 23:33 GMT+01:00 Ross Laird <[email protected]>: > Postgresql authentication can be tricky. > You may need to make changes to your pg_hba.conf file. Like so: > > # Database administrative login by Unix domain socket > local all postgres peer > # TYPE DATABASE USER ADDRESS METHOD > # "local" is for Unix domain socket connections only > local all all peer > # IPv4 local connections: > host all all 127.0.0.1/32 md5 > # IPv6 local connections: > host all all ::1/128 md5 > # Allow replication connections from localhost, by a user with the > # replication privilege. > #local replication postgres peer > #host replication postgres 127.0.0.1/32 md5 > > Ross, thanks for the tips! My pg_hba.conf is exactly the same.
> Also, this tutorial might help: > > http://rosslaird.com/blog/building-a-project-with-mezzanine/ > I realized that I was not using the correct owner of the database on the server I've tried changing listen_addresses to accept any using * (as in your tutorial) and now I get a different error, which I translate as: no entry in pg_hba.conf for host "x.x.x.x", user "project", database "project", SSL disabled The host is my public IP. It's listening to any address but it needs a specific entry for my IP, so I've added: host all all x.x.x.x/32 md5 I've repeated the commands above to sync the databases and I got no messages in the terminal. However, the problem persists. I've also tried to repeat the deploy with 'fab remove & fab create & fab deploy', but it's not using my database. My last option is manually dumping the database. So I tried: 1. fab create 2. pg_dump -Fc dbname > db.dump (on localhost and copied db.dump on the server) 3. pg_restore -d project db.dump (on the server) 4. fab deploy But I get some errors when I run pg_restore and when I run 'fab deploy' I get this error: django.db.utils.ProgrammingError: ERROR: permission denied for the relation django_content_type I'm starting running out of hope... Your tutorial about deployment is still on your TODO list? -- You received this message because you are subscribed to the Google Groups "Mezzanine Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
