![]() Net stop postgresql and net start PostgreSQL. You can Start and Stop the services after service registration using the command. Type the pg_ctl register -N “postgresql” -D “C:\Program Files\pgsql\data” command then enter to finish.ģ. Add the IP address of your postgresql server below of line 84 in the pg_hba.conf and save the file.ġ.Open the command prompt, type cd\ then enter and type the cd “Program Files\pgsql\bin” then enter to continue.Ģ. Once you have installed the server, you need to initialize the PostgreSQL database. After changing the default version using the aforementioned command, its time to install the PostgreSQL server and client packages. Edit the line 59 to 63 from nf, uncomment the listen_addresses and port by removing the # and change the localhost to * then save the file. Step 3: Install the PostgreSQL Server Package. It will get new password for postgres because of -W in the command then enter your new password for postgres.Įnter again your new password for postgres.įinish installing your new postgres in data directory.Ĭonfigure pg_hba.conf and nfġ. PostgreSQL supports multiple authentication methods. A role can represent a database user or a group of database users. Type the initdb -U postgres -W -E utf8 -D “Program Files\pgsql\data” then enter to continue. The PostgreSQL installation provides a command-line client program called psql, which can be used to login to the server. PostgreSQL handles the database access permissions using the concept of roles. Open the command prompt, type cd\ then enter and type the cd “Program Files\pgsql\bin” then enter to continue.Ĥ. Create data folder in c:\Program Files\pgsql\ directory.ģ. Unzip the postgresql-9.2.9-1-windows-binaries.zip file in the C:\Program Files directory. ![]() Microsoft Visual C++ 2008 redisbutableĢ. postgresql-9.2.9-1-windows-binaries.zipġ. Installing Postgresql 9.2 zip file and Remote Configurationġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |