Skip to main content

Installing PostgreSQL on Windows

Installing PostgreSQL on Windows
Follow the following step to install PostgreSQL on windows.
Step 1: Download the expected version suitable for you from the link
Step 2: Double click on the installer file, an installation wizard will appear and guide you through multiple steps where you can choose different options that you would like to have in PostgreSQL. The following illustrates each step and its options for installation. If you install a different version, you may get additional steps. 
PostgreSQL Install on Window Step 2
Step 3: In this step of the installation process would be to select the directories for installation location where PostgreSQL would be installed. By default, it is stored under the C:\\ProgramFile.
Step 4: Enter the password for the database super-user and service account.
PostgreSQL Install on Window Step 4
Step 5: Enter the port for PostgreSQL. Make sure that no other applications are using this port. Leave it as default if you are unsure.
PostgreSQL Install on Window Step 5
Step 6: Choose the default locale used by the database.
PostgreSQL Install on Window Step 6
Step 7: You’ve completed providing information for the PostgreSQL installer. Click the Next button to install PostgreSQL
PostgreSQL Install on Window Step 7
Step 8: The installation may take a few minutes to complete.
PostgreSQL Install on Window Step 7
After finish the installation please check and open the PostgreSQL server.
WindowàPostgreSQLàpgAdmin and click. It will ask you for the admin password. Just enter the password you’ve used in the installation step.
Now PostgreSQL installation process is done, you are ready to use PostgreSQL.

Popular posts from this blog

Add day to ISODate in MongoDB

We can use $add operator to add days in ISODate in mongodb, $add is the Arithmetic Aggregation Operator which adds number and date in mongodb.

{ $add: [ <expression1>, <expression2>, ... ] }

Note:  If one of the argument is date $add operator treats to other arguments as milliseconds to add to the date.
Example: Suppose we have a Test collection as below.

{"Title" : "Add day to ISODate in MongoBD","CreatedDate" : ISODate("2016-07-07T08:00:00.000Z")}

Query to add 2 days in CreatedDate

db.Test.aggregate([      { $project: { Title: 1, AddedDate: { $add: [ "$CreatedDate", 2*24*60*60000 ] } } }    ])


{ "_id" : ObjectId("579a1567ac1b3f3732483de0"), "Title" : "Add day to ISODate in MongoBD", "AddedDate" : ISODate("2016-07-09T08:00:00.000Z") }

Note: As mentioned in above note we have to convert days in millisecond because $add operator treat to other arg…

Remove special character from string in MongoDB

Problem: Suppose wehave a collection and one field is type string contains some special character (like !@#$%) and we don’t want these special character.
Solution: We can easily remove the special character from field using script “replace(/[^a-zA-Z 0-9 ]/g, '')” in our query.  How can we remove special character from string using this script please see following example.
Example: Suppose we have a collection “EduSurvey “where we are collecting information from institutions.

{Name:"JB institute”, About:"This is good one collage for MBA", Information:"This $%%institute ##has good faculty etc$$"}
{Name:"MK institute”, About:"This is good one collage for MCA", Information:"This$$%# is the dummy text12"}
{Name:"MG institute”, About:"This is good one collage for B,Tech", Information:"This# institute@ has&* good infrastructure"}

Did you notice Information fields contains some special character so we…