Set up the pg gem - postgresql in development

Question

I'm using Cloud9 on AWS in development and EB for deployment.   
Found a lot of old stuff, but having problem to install **pg gem**.  
  
1. started with codestar, using ruby on rails app  
2. for now with elastic beanstalk  
3. using IDE Cloud9   
4. added RDS Postgresql for the EB  
5. installed all gems needed, except the pg gem   
  
- postgresql set in database config for dev and production  
- postgresql93-devel added in the packages.conf  
  
- tried to add libpq-dev - NOT WORKING (?)

```
sudo yum install libpq-dev
```

- this worked (not sure if this is correct)

```
sudo yum install postgresql-libs
```

**Still error when installing the gem:**   
  
-------  
_Building native extensions.  This could take a while..._  
_ERROR:  Error installing pg:_  
        _ERROR: Failed to build gem native extension._  
  
    _current directory: /usr/local/rvm/rubies/ruby-2.4.1/lib/ruby/gems/2.4.0/gems/pg-0.21.0/ext_  
_/usr/local/rvm/rubies/ruby-2.4.1/bin/ruby -r ./siteconf20171207-7455-1v09v4h.rb extconf.rb_  
_checking for pg_config... no_  
_No pg_config... trying anyway. If building fails, please try again with_  
 _--with-pg-config=/path/to/pg_config_  
_checking for libpq-fe.h... no_  
_Can't find the 'libpq-fe.h header_  
_*** extconf.rb failed ***_  
_Could not create Makefile due to some reason, probably lack of necessary_  
_libraries and/or headers.  Check the mkmf.log file for more details.  You may_  
_need configuration options._  
  
**Any new ideas how to setup Postgresql with Cloud9 on AWS?**  
  
Edited by: mikesk on Dec 7, 2017 2:50 AM

Answer

I just ran into this myself, it turns out the package you need is called postgresql-devel on RHEL systems. Try:

```
sudo yum install postgresql-devel
```

I agree this should work out of the box. Until we are actually able to set our own base images, or AWS fixes this, though, that should suffice.

Answer

As of February 27, 2018, the above solution is not working on Amazon Linux Cloud9. Not sure whether Amazon updated its AMI so that it no longer functions or what.  
  
The pg_config file in /usr/bin references postgresql-9.6, but all of the components necessary to compile the pg gem for pg-9.6 are not installed when booting up the AMI for the first time. What got it working for me was the following:

```
sudo yum install postgresql96 postgresql96-server postgresql96-libs postgresql96-contrib postgresql96-devel
 ```

Answer

Thanks very much for posting the instructions. I'd like to ask if anyone knows how to start the postgresql service after installing postgresql on AWS Cloud 9.  
  
I have tried to run
 `sudo service postgresql start`
 without much success.  
  
Similarly, I've also tried to run the following without much success

```
 systemctl enable postgresql-9.6.service
 systemctl start postgresql-9.6.service
```

Any assistance would be much appreciated!

Answer

You can follow the instructions on this article: https://medium.com/@floodfx/setting-up-postgres-on-cloud9-ide-720e5b879154  
  
sudo yum install postgresql postgresql-server postgresql-devel postgresql-contrib postgresql-docs  
  
sudo service postgresql initdb

Set up the pg gem - postgresql in development

관련 콘텐츠