SQLPro for Postgres is an advanced but thin client PostgresSQL database, allowing quick and easy access to. SQLPro for Postgres 1.0.315| Mac OS X| 9 MB. SQLPro for Postgres is an advanced but thin client PostgresSQL database, allowing quick and easy access to. Postgres Client For MacHere are the steps I used to set up Postgres in Mac OSX. Most of what is written here was learned from. Best ssh and sftp client for mac. I am saving my notes here in case that site gets removed. Get the Remote Desktop client. Follow these steps to get started with Remote Desktop on your Mac: Download the Microsoft Remote Desktop client from the Mac App Store.; Set up your PC to accept remote connections. Microsoft remote desktop connection client for mac download. With Microsoft Remote Desktop, you can connect to a remote PC and your work resources from almost anywhere.Experience the power of Windows with RemoteFX in a Remote Desktop client designed to help you get your work done wherever you are. Mysql Client For MacInstall Postgress using brew If you don’t have, install it first. Then simply run the command: brew install postgres Initialize Postgres This command initializes the database. Initdb /usr/local/var/postgres Set up Postgres to run at startup Check if the directory ~/Library/LaunchAgents exists. Create it if it doesn’t exist. Find the plist file that came with the postgres install. I found mine at /usr/local/Cellar/postgresql/9.3.4/homebrew.mxcl.postgresql.plist. Copy the plist file to the LaunchAgents directory. Cp /usr/local/Cellar/postgresql/9.3.4/homebrew.mxcl.postgresql.plist ~/Library/LaunchAgents/ Now use launchctl to load the file using this command: launchctl load -w homebrew.mxcl.postgresql.plist Now when the computer reboots, postgres will automatically startup. Additional Postgres Commands Create a user Postgres has a shell command called createuser which will create a user for Postgres. Db2 Client For Mac Os XUse it right from the OSX terminal command line like this: createuser --pwprompt tunnelsup If it asks you questions about the user you can say ‘n’ for all of the questions. If you wish to create a user without a password just take the --pwprompt off the command. Create a database Here is the command: createdb -Otunnelsup -Eutf8 mysite_development The -O indicates the user that will become the owner of the database. Access the Database The following command can be used to log into the database. Psql -U tunnelsup -W mysite_development The -U means to login using that username and the -W means to prompt for a password. To exit the shell hit Ctrl+ d Starting a new Rails project In case you’re using this guide to get started using rails here’s how I would start the new rails app. Db2 Client For Mac![]() Postgresql Gui ClientBest bittorrent client for mac 2017. # Create the rails project rails new projectname --database=postgresql cd projectname # Create the Postgres user createuser projectname # Create the databases createdb -Oprojectname -Eutf8 projectname_development createdb -Oprojectname -Eutf8 projectname_test # Create some models/controllers etc rails generate controller site rails generate model # Run migrations rake db:migrate # Start the server rails server In dev I may not use a password for the database user. This makes it easier for me to get started and I don’t even have to edit the database.yml file. Posted by Jack Nov 13 th, 2014.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |