pivotal-sprout / sprout-postgresql Goto Github PK
View Code? Open in Web Editor NEWLicense: MIT License
License: MIT License
This is looking awesome. We were having some problems where our default database encoding was ASCII, and we couldn't figure out where that was coming from so I absolutely welcome the addition of this cookbook.
I've been testing it out on our machines over here at wanelo and are noticing that our databases get dropped everytime that be soloist
runs. Are you planning on changing that default?
It seems like the first run it should delete the initially incorrectly encoded database and then recreate it, but not each subsequent run.
Thanks!
James
The recipe sprout-postgresql::create_current_user_db
fails to connect to postgres:
* execute[create a database for the current user] action run[2016-02-01T17:14:09-07:00] INFO: Processing execute[create a database for the current user] action run (sprout-postgresql::create_current_user_db line 5)
[2016-02-01T17:14:09-07:00] INFO: Processing execute[Guard resource] action run (dynamically defined)
createdb: could not connect to database template1: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Because the postgres process failed to start using launchctl load -w /Users/pivotal/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
When this command was executed, there was no reported failure, so sprout proceeded to run, but the postgres process actually failed to come up.
The contents of /usr/local/var/postgres/server.log
include the following errors:
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
LOG: received smart shutdown request
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
LOG: skipping missing configuration file "/usr/local/var/postgres/postgresql.auto.conf"
FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 9.3, which is not compatible with this version 9.5.0.
LOG: skipping missing configuration file "/usr/local/var/postgres/postgresql.auto.conf"
If a machine has previously had an older version of postgres (e.g. 9.4) installed, and a newer one (e.g. 9.5) is being installed by the cookbook, attempts to use postgres will likely fail with an error like:
createdb: could not connect to database template1: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
The logs in /usr/local/var/postgres/server.log
will likely say something like:
FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 9.4, which is not compatible with this version 9.5.4.
We don't want to take the unexpected action of emptying /usr/local/var/postgres
or migrating the database on behalf of the user, but we should detect this state and fail with a clear explanation of what is happening, and maybe include potential solutions such as outlined in this upgrading guide.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.