by skufel | Mar 14, 2016 | Automation, Databases, Infrastructure, Scripting, SysAdmin, Windows
Code snippet from old archives. It shows how to import Windows event log entries to database. Important is to setup database and table accordingly, so it contains apropriate columns. Set objConn = CreateObject("ADODB.Connection") Set...
by skufel | Sep 24, 2012 | Databases
After installation PostgreSQL is listening on localhost only. To change that adjustment has to be done in postgresql.conf. Default location of configuration file /var/lib/pgsql9/data/postgresql.conf. Following line has to be added: listen_addresses = '*' After that...
by skufel | Sep 24, 2012 | Databases
After I instaled PostgreSQL on Amazon Linux AMI, first thing after database server was up and running I start thinking how to create user with administrative privileges, so I can access it using some management applications. So, here is how to create superuser and set...
