search

seixasfelipe / cleaners

Cleaners - Management Application
MIT License
2 stars 0 forks source link

Which postgres are you guys using? #9

Closed fraga closed 11 years ago

fraga commented 11 years ago

Which version do you guys have?

I currently have postgres (PostgreSQL) 9.2.3

seixasfelipe commented 11 years ago

9.2.2.0 (20)

Le samedi 2 mars 2013, Rodrigo Fraga a écrit :

Which version do you guys have?

I currently have postgres (PostgreSQL) 9.2.3

— Reply to this email directly or view it on GitHubhttps://github.com/seixasfelipe/cleaners-panamby/issues/9 .

fabianoalmeida commented 11 years ago

I'm having problems to install postgres on my Mac OS. :unamused: However, I'm using SQLite3 to test and make some improvements. :no_mouth:

fraga commented 11 years ago

ok tks =)

seixasfelipe commented 11 years ago

Do you want to change dev database to sqlite3? I chose postgre in dev env just to avoid some problems when deploying. go ahead, change and commit :)

Le samedi 2 mars 2013, Rodrigo Fraga a écrit :

ok tks =)

— Reply to this email directly or view it on GitHubhttps://github.com/seixasfelipe/cleaners-panamby/issues/9#issuecomment-14339510 .

fabianoalmeida commented 11 years ago

@seixasfelipe don't worry about that. I'm wrong cause I'm using SQLite3. I should be using Postgres, but I didn't get to install it on OSX. :unamused:

How did you do that? Can you show me all the steps? :disappointed:

seixasfelipe commented 11 years ago

Just go to: http://postgresapp.com

Download and run the Postgre.app, that's it. An elephant icon will appear in your bar (up) and you can choose to start the database when you want.

BTW, I use SQuirrelSQL to see databases, what application do you guys use?

On Sun, Mar 3, 2013 at 8:09 PM, Fabiano Almeida notifications@github.comwrote:

@seixasfelipe https://github.com/seixasfelipe don't worry about that. I'm wrong cause I'm using SQLite3. I should be using Postgres, but I didn't get to install it on OSX. [image: :unamused:]

How did you do that? Can you show me all the steps? [image: :disappointed:]

— Reply to this email directly or view it on GitHubhttps://github.com/seixasfelipe/cleaners-panamby/issues/9#issuecomment-14359965 .

fraga commented 11 years ago

I use brew to install softwares in my mac. And I use command line most of the time to check on databases (log on the database, check tables structures, etc). My dev env is vim. Will check this SQuirrelSQL, seems to be interesting...

fabianoalmeida commented 11 years ago

Hmmm... Ok, I'll try it at night and post here.

BTW, we have the same name to development and production environment: database: cleaners. It's more common define the environment on the database name, like cleaners_development for development and cleaners_production for production. What do you think?

@seixasfelipe Responding your question... Postgres has a simple but useful app called pgAdmin III that can be installed with postgres, if you want. This app, you mention (SQuirrelSQL), is more complete? What do you like in this app?

@fraga I'm having problems when I run brew doctor because I have configured a Oracle client in my OSX for a project. So, I can't update my brew to install postgres using it. I already used vim, nowadays I'm using Sublime Text 2. It's rocks!

seixasfelipe commented 11 years ago

@fabianoalmeida The idea to have different names to databases is great, however we are using heroku as our production environment, so the name of the production database will always be replaced by heroku api when we deploy the app :smile:

I've never used pgAdmin, I'll give it a try someday.. I usually execute some sql commands via console (terminal) but sometimes I prefer to see some database information using SQuirrelSQL..

fabianoalmeida commented 11 years ago

@seixasfelipe I'm having problems to install and use postgres on my Mac. Can you show us how did you install and configure it? Please, help me. :blush:

fabianoalmeida commented 11 years ago

@seixasfelipe I solved it and I created a new gist to memorize that :laughing:

seixasfelipe commented 11 years ago

Perfect! I didn't remember how I'd installed anyway

fabianoalmeida commented 11 years ago

@seixasfelipe BTW, I'm having problems with that again. :confused: I'm using mysql to test and develop. Holy shit! :pensive:

seixasfelipe commented 11 years ago

Can you post your problem to us? Did you create a user for postgres with granted permission for the database?

fabianoalmeida commented 11 years ago

I showed my problem here. I don't know what is going on. After I installed this worked once. :cry: