Práticas de Informática

my "pgini":

#!/bin/sh
# the first very important set-variable
CYGWIN=server
export CYGWIN
# the second very important set-variable - to unset it worked for me
(then language-setting is C).
unset LANG
echo
# the third very important set-variable
PATH=/usr/bin:/usr/sbin:$PATH
export PATH
#echo "IPC-Daemon starten..."
echo
echo "cygserver-config starting..."
cygserver-config
echo "sygserver starten..."
cygserver &
ps -f
echo
echo "initdb starting..."
initdb -D /var/postgresql/data
ps -f
./db-stop

now "db-start":

#!/bin/sh
CYGWIN=server
export CYGWIN
PATH=/usr/bin:/usr/sbin:$PATH
export PATH
echo
echo "sygserver starting..."
cygserver &
ps -f
echo
echo "PostgreSQL starting..."
postmaster -i -D /var/postgresql/data &
ps -f

and finally "db-stop":

#!/bin/sh
echo
echo "PostgreSQL finishing..."
pg_ctl stop -w -D /var/postgresql/data -s -m smart
ps -f
echo
echo "cygserver finishing..."
kill $(ps -f | grep cygserver | awk '{print $2}')
ps -f

psql --version

cygrunsrv --remove ipc-daemon2
net user postgres ******** /add
net user postgres /fullname:postgres
net user postgres /comment:'PostgreSQL User Account'
net user postgres /homedir:"$(cygpath -w /home/postgres)"
mkpasswd -l -u postgres >> /etc/passwd
ipc-daemon2 --install-as-service

cygrunsrv --remove postmaster
mkdir /usr/share/postgresql/data
chown postgres /usr/share/postgresql/data
initdb -D /usr/share/postgresql/data
cygrunsrv --install postmaster --disp 'Postmaster PostgreSQL' --path /usr/bin/postmaster --args '-D /usr/share/postgresql/data -i' --dep ipc-daemon2 --termsig INT --shutdown -u postgres


$conn = pg_connect("host=localhost
port=5432
dbname=template1
user=postgres
password=********");
$sql = "SELECT current_date AS today;";
$result = pg_query($conn, $sql);
$row = pg_fetch_object($result, 0);
echo "Today is: " .$row->today;
?>