Tags » Postgresql

IF ELSE dalam Query :: Postgre

Sampel data tabel ‘content’ di atas terdapat field ‘status’ dengan initial value. Bagaimana untuk mengubah status tersebut menjadi : misal 1 dimaksudkan untuk status Publish dst, diubah langsung pada query bukan pada bahasa program. 23 more words

Case-when If-else

Postgres Backup and restore database

Following are some of the commands I use to backup and restore my postgres databases and tables.

  1. pg_dump is a nifty utility designed to output a series of SQL statements that describes the schema and data of your database.
  2. 801 more words

Ten Questions to Consider Before Choosing Cassandra

1. Do you know what your queries will look like ?

In traditional SQL you design your data model to represent your business objects. Your queries can then evolve over time and can be ad-hoc. 1,247 more words


Rails 4: gem install pg (when using the Postgresql App on OS X)

If you are getting a build error from Gem when trying to install the PostgreSQL gem called ‘pg’ and you are using the PostgreSQL App instead of installing PostgreSQL via Brew or some other method, it is because Gem cannot find the PostgreSQL config in the standard locations. 140 more words


Postgresql 9.2 monitoring with Adagios on CentOS 7

On the PostgreSQL server:

Note: You may need to deal with SELinux.

Install some needed perl modules, download the check script and make it executable: 1,052 more words


Configuring Postgresql and Dropdb

Seems like an on-going nightmare. I am configuring a new Ubuntu 14.04 system and having troubles with getting passwords from .pgpass. Here are the fundamentals: 178 more words

PyCharm, Django Dev Server and "password authentication failed for user"

This stuff drives me crazy. I was cruising along, run the Django dev server from the command line. Everything was working well. Then I decided to do some debugging, so I configured the PyCharm Django dev server and got this error: 153 more words