fix postgresql configuration and connection info for testing