2014-03-03 23:33 GMT+01:00 Ross Laird <r...@rosslaird.com>: > 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 mezzanine-users+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
