Tags » Postgresql

pgAdmin backup error because of server version mismatch

I got following error on pgAdmin III when backuping table/db :

/usr/bin/pg_dump –host localhost –port 5433 –username “postgres” –no-password –format custom –verbose –file “/home/yusuf/Desktop/client_service_centre” –table “public.client_service_centre” “logistics”

31 more words

Connect to the Tableau PostgreSQL database and Create worksheet for Tableau server monitoring

Today we will connect database of PostgreSQL of Tableau and create work sheet base on that database.

Tableau will store every data for tableau server statistics in PostgreSQL. 314 more words


Building one HTTP client in PostgreSQL with PL/Python

Don’t ask me way, but I need to call to a HTTP server (one Silex application) from a PostgreSQL database.

I want to do something like this: 359 more words


Setting Up Cross-Region Replication of AWS RDS for PostgreSQL

As of today AWS RDS for PostgreSQL1 does not offer cross-region replication. Short of switching to one of the RDS offerings that do support it, there is a few options to consider. 307 more words


Installing PostgreSQL and PHPPgMyAdmin on Ubuntu 14

here is how to install PostgreSQL & PHPPgMyAdmin  on Ubuntu 14 in easy way :

  1.  sudo apt-get install phppgadmin
  2. sudo cp /etc/apache2/conf.d/phppgadmin /etc/apache2/conf-enabled/phppgadmin.conf
  3. sudo /etc/init.d/apache2 restart…
  4. 81 more words

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