When you design your table, you choose to add a primary key constraint for one or more column while create the same. Column attached with primary key constraint should contain UNIQUE and NOT NULL values. We all know that. But PostgreSQL does not force this constraint while creating a new table, you might forget to add one (missing morning coffee may be). I tried creating a table without adding primary key constraint in PostgreSQL CREATE TABLE weather ( city character varying(80), temp_lo integer, temp_hi integer, prcp real, date date ); This took off and created the weather table successfully. Now when I tried to view data (which I inserted after creating the table) using pgAdmin III, it displayed hint (warning, I would say) as Edit table data without primary key This warning message say, I will not be able to edit or change existing row data since I do » Read more
Once you have your PostgreSQL database server installed, up and running, due to security reasons by default remote access to connect with your database instance is disabled. If you try connecting with your PostgreSQL database server from client machine, you will encounter error. could not connect to server: Connection refused (0x0000274D/10061) Following screenshot displays error I received when trying to connect from a windows client machine using pgAdmin III Following below steps you will be able to enabled remote access to PostgreSQL database server. Before even we start it is important to know that there are two configuration files (and others) which control how your database server works. This configuration files contains settings that needs to be tweaked or changed to make your database instance run as per your needs. postgresql.conf (Used to set various parameters that affect the database) pg_hba.conf (Used to control client authentication, » Read more
Ok so you know the blah blah of how PostgreSQL is awesome relation database (RDBMS) and great for reliable transactions, good for so many things, lots of enterprise features and gives concurrency without read locks and stuffs. If you are not aware of this RDBMS, then I would recommend you search for advantages of using PostgreSQL and what is served in its plate. PostgreSQL is pronounced mostly as "post gray sequel" or "post ge are ee as que el" (I am sounding very dramatic here). Back to the post now, Fire up your Ubuntu 14.04 to start the installation. It would almost follow the same for most of the Ubuntu flavors out there. First step - you know the drill :) sudo apt-get update Next step: sudo apt-get install postgresql postgresql-contrib postgresql installs the core PostgreSQL engine and RDBMS around which everything else is build. The » Read more
