analytics-services | Analytics services use python libraries such as Pandas

Download latest Windows PostgreSQL Installer and follow windows installation steps. Alternatively, can download Windows PostgreSQL Binary Archive and extract the zip file. POSTGRE_SQL_HOME is the path to the unzipped PostgreSQL pgsql directory. Create data directory in POSTGRE_SQL_HOME/pgsql and initialize the postgres database using pg_ctl init command from pg_ctl utility. Start the Posgres server in background with the initialized data directory. PostGreSQL runs by default on port 5432. Create default postgres as superuser and set the password as secret. Alternatively, the password of postgres user can be changed as below after logging into psql. Register Posgres server with data directory path as a windows service. Create a new user named appuser and new database named appdb using below psql commands. Create a new database appdb and grant all privileges for the database to user appuser. user named appuser and new database named appdb using below psql commands. Alternatively, database can be created using the createdb utility as below. Then login into psql with appuser and appdb database. To remove the user appuser and database appuser, login into psql using postgres superuser and execute below drop commands.
Download latest Windows PostgreSQL Installer and follow windows installation steps.
Alternatively, can download Windows PostgreSQL Binary Archive and extract the zip file. POSTGRE_SQL_HOME is the path to the unzipped PostgreSQL pgsql directory.
Create data directory in POSTGRE_SQL_HOME/pgsql and initialize the postgres database using pg_ctl init command from pg_ctl utility. $ pg_ctl -D "POSTGRE_SQL_HOME/pgsql/data" init
Start the Posgres server in background with the initialized data directory. PostGreSQL runs by default on port 5432. $ pg_ctl -D "POSTGRE_SQL_HOME/pgsql/data" -l logfile start
Create default postgres as superuser and set the password as secret. $ createuser --password --superuser postgres
Alternatively, the password of postgres user can be changed as below after logging into psql. $ psql -U postgres postgres=# \password postgres=# ALTER USER postgres WITH PASSWORD 'new_password';
Register Posgres server with data directory path as a windows service. $ pg_ctl register -N postgres -D "POSTGRE_SQL_HOME/pgsql/data"
Create a new user named appuser and new database named appdb using below psql commands. $ psql -U postgres postgres=# CREATE USER appuser WITH PASSWORD 'secret123';
Create a new database appdb and grant all privileges for the database to user appuser. user named appuser and new database named appdb using below psql commands. postgres=# CREATE DATABASE appdb; postgres=# GRANT ALL PRIVILEGES ON DATABASE appdb TO appuser; postgres=# \c appdb;
Alternatively, database can be created using the createdb utility as below. Then login into psql with appuser and appdb database. $ createdb --owner appuser appdb $ psql -h localhost -U appuser -d appdb postgres=# \q
To remove the user appuser and database appuser, login into psql using postgres superuser and execute below drop commands. $ psql -U postgres postgres=# DROP DATABASE appdb; postgres=# DROP USER appuser;
While running pg_ctl.exe register command, please ensure that the windows command prompt is running as administrator, to avoid pg_ctl: could not open service manager error.
If the data directory is not initialized pg_ctl returns the error pg_ctl: directory "C:/Installs/pgsql/data" is not a database cluster directory.
The postgres user is not created by default and hence should be created using createuser utility to avoid the FATAL: role "postgres" does not exist error.