# Existing postgres database

**URL:** <https://www.ruby-forum.com/t/existing-postgres-database/113205>\
**Category:** Ruby\
**Created:** [August 28, 2007, 7:14pm UTC](https://www.ruby-forum.com/t/existing-postgres-database/113205 "2007-08-28T19:14:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![glacius](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/dec6dc/32.png) [@glacius](https://www.ruby-forum.com/u/glacius)\
**Post date:** [August 28, 2007, 7:14pm UTC](https://www.ruby-forum.com/t/existing-postgres-database/113205/1 "2007-08-28T19:14:06Z")

</div>

Quick simple question

I am walking through some rails tutorials and would like to test it  
with our corporate database, I am not very familiar with the platform  
but I am learning. Are there any guides,tutorials or advice I can get  
or be given to me on connecting to the remote postgres database,the  
most stable adapter and how to set it up in database.yml

Thanks guys

---

<div class="post-metadata">

**Author:** ![glacius](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/dec6dc/32.png) [@glacius](https://www.ruby-forum.com/u/glacius)\
**Post date:** [August 28, 2007, 10:11pm UTC](https://www.ruby-forum.com/t/existing-postgres-database/113205/2 "2007-08-28T22:11:38Z")

</div>

On 8/28/07, Gian H. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> 

The best place for this question would be:

[http://groups.google.com/group/rubyonrails-talk](http://groups.google.com/group/rubyonrails-talk)

As for your question the postgres gem is a bit faster than ruby-pg I  
believe. However installing it in Windows takes a mild amount of  
effort.

## Configuring database.yml is simple too. Your adapter will be postgresql the rest is pretty self-explanatory, username is the name of a database user that can access that particular database and the password is that users password in the DBMS.

“Hey brother Christian with your high and mighty errand, Your actions  
speak  
so loud, I can’t hear a word you’re saying.”

-Greg Graffin (Bad Religion)

---

<div class="post-metadata">

**Author:** ![glacius](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/dec6dc/32.png) [@glacius](https://www.ruby-forum.com/u/glacius)\
**Post date:** [August 28, 2007, 10:20pm UTC](https://www.ruby-forum.com/t/existing-postgres-database/113205/3 "2007-08-28T22:20:41Z")

</div>

> On 8/28/07, Gian H. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:
> 
> Quick simple question
> 
> I am walking through some rails tutorials and would like to test it  
> with our corporate database, I am not very familiar with  
> the platform  
> but I am learning.

Just so someone said it: don’t experiment against production databases.  
Don’t even experiment against databases on the same server as production  
databases. If you mess up and lock up a daemon tied into a production  
system  
or worse yet trash a live database, you’ll get into very big trouble  
with  
your DBA. If you’re the DBA, you shouldn’t even be considering it.

Felix