Create_DB_pgAdminII.htm
 
CREATE DATABASE
Name
CREATE DATABASE -- create a new database
 

Description

CREATE DATABASE creates a new PostgreSQL database.

To create a database, you must be a superuser or have the special CREATEDB privilege. See CREATE USER.

 

 
CREATE DATABASE name
                [ [ WITH ] [ OWNER [=] dbowner ]
                [ TEMPLATE [=] template ]
                [ ENCODING [=] encoding ]
                [ TABLESPACE [=] tablespace ]
                [ CONNECTION LIMIT [=] connlimit ] ]

 

password: postgre_manas9
Expands the nodes:

-- Database: postgres
-- DROP DATABASE postgres;
CREATE DATABASE postgres
WITH OWNER = postgres
ENCODING = 'UTF8'
TABLESPACE = pg_default
LC_COLLATE = 'English_United States.1252'
LC_CTYPE = 'English_United States.1252'
CONNECTION LIMIT = -1;
 
The following was tried to tune up phpPgAdmin 5.1
Server configuration: Expand and crawl Tool main menu:

TO 120.0.0.1/32 or any other did not help to bypass security contains of phpPPgMyAdmin

Din not connect: with user postgres , pwd: postgre_manas9 , used in pgAdminIII.exe in bin folder.

You will have to add an entry in the form host template1 postgres 192.168.0.0/24 md5 for IPV4 or host template1 postgres ::ffff:192.168.0.0/120 md5 for IPV6 networks to the pg_hba.conf file. Below is ipconfig makeover of this worstation.

Note unsuccessful login: did not find help to this issue ( FYI: With Linux I did not have any issues, ).

I will deal with phpAPGAdmin at later point

 
The followings were the attempts to create new user , or database

Adding a New DB as an user "postgres", won't be goo idea as it contains all the maintenance itineraries og PostGrsSQL database. You must take dive into the help line.

Below is the image taken from the help line

I would spec all in details.