Skip to content

Instantly share code, notes, and snippets.

@alex-zige

alex-zige/gist:101751fc92d1410b65b8

Last active August 29, 2015 14:09
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save alex-zige/101751fc92d1410b65b8 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save alex-zige/101751fc92d1410b65b8 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. alex-zige revised this gist Nov 14, 2014. 1 changed file with 4 additions and 0 deletions.
    4 changes: 4 additions & 0 deletions gistfile1.md
    View file
    Original file line number Diff line number Diff line change
    @@ -30,6 +30,10 @@
    }
    }
    ```

    ##Add missing postgres package
    In OS package, Add postgresql93-devel

    ##Add security group -> opsworks-rails-layer.

    ## Enable postgis extension
  2. alex-zige revised this gist Nov 14, 2014. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion gistfile1.md
    View file
    Original file line number Diff line number Diff line change
    @@ -10,7 +10,7 @@

    ##Use custom Stack JSON

    *Becareful with adapter
    *Be careful with adapter

    ```
    {
  3. alex-zige revised this gist Nov 14, 2014. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions gistfile1.md
    View file
    Original file line number Diff line number Diff line change
    @@ -3,7 +3,7 @@


    #### Opsworks has a bug, even you registerd a postgres RDS, the adapter is still using 'mysql'
    FUXXXXX WORKAROUND:
    ### WORKAROUND:

    ##Create mysql layer (fake) don't assign instances

    @@ -45,7 +45,7 @@ psql -h <host> -p <port> -u <database>

    ##Then db:migrate and db:seed

    If you created your db before. time to drop it and recreat it!
    If you created your db before. time to drop it and recreate it!



  4. alex-zige revised this gist Nov 14, 2014. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion gistfile1.md
    View file
    Original file line number Diff line number Diff line change
    @@ -2,7 +2,7 @@
    ##Create RDS with postgres


    ## Opsworks has a bug, even you registerd a postgres RDS, the adapter is still using 'mysql'
    #### Opsworks has a bug, even you registerd a postgres RDS, the adapter is still using 'mysql'
    FUXXXXX WORKAROUND:

    ##Create mysql layer (fake) don't assign instances
  5. alex-zige revised this gist Nov 14, 2014. 1 changed file with 3 additions and 0 deletions.
    3 changes: 3 additions & 0 deletions gistfile1.md
    View file
    Original file line number Diff line number Diff line change
    @@ -2,6 +2,9 @@
    ##Create RDS with postgres


    ## Opsworks has a bug, even you registerd a postgres RDS, the adapter is still using 'mysql'
    FUXXXXX WORKAROUND:

    ##Create mysql layer (fake) don't assign instances


  6. alex-zige created this gist Nov 14, 2014.
    50 changes: 50 additions & 0 deletions gistfile1.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,50 @@

    ##Create RDS with postgres


    ##Create mysql layer (fake) don't assign instances


    ##Use custom Stack JSON

    *Becareful with adapter

    ```
    {
    "deploy": {
    "ticket_to_paradise": {
    "database": {
    "adapter": "postgis",
    "encoding": "utf8",
    "host": "your-host",
    "port": "5432",
    "database": "attp_db_2",
    "pool": "5",
    "username": "your-password",
    "password": "your-username",
    }
    }
    }
    }
    ```
    ##Add security group -> opsworks-rails-layer.

    ## Enable postgis extension

    ###login into psql

    ```
    psql -h <host> -p <port> -u <database>
    ```

    ### Add [postgis extension](http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.html#Appendix.PostgreSQL.CommonDBATasks.PostGIS)


    ##Then db:migrate and db:seed

    If you created your db before. time to drop it and recreat it!