My 2 cents

lirc installation on ubuntu 9.10

2009-12-30T22:24:00.018+09:00

Finally I was able to make my SONY remote-con and receiver to work on my Ubuntu 9.10.

Hardwares:
SONY VAIO GigaPocket Remote controller RM-GP3 and
SONY VAIO PCVA-IR3U Infrared Receiver

(1) Check whether you have lirc installed.


# dpkg -l | grep lirc
ii liblircclient0

Install lirc


# apt-get install lirc
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  libftdi1 setserial
Suggested packages:
  lirc-modules-source lirc-x
The following NEW packages will be installed:
  libftdi1 lirc setserial
0 upgraded, 3 newly installed, 0 to remove and 164 not upgraded.
Need to get 576kB/628kB of archives.
After this operation, 2769kB of additional disk space will be used.
Do you want to continue [Y/n]? y
Get:1 http://archive.ubuntu.com karmic/main libftdi1 0.16-2 [17.5kB]
Get:2 http://archive.ubuntu.com karmic/universe lirc 0.8.6-0ubuntu2 [559kB]
Fetched 576kB in 3s (157kB/s)
Preconfiguring packages ...
dpkg: warning: obsolete option '--print-installation-architecture', please use '--print-architecture' instead.
Selecting previously deselected package libftdi1.
(Reading database ... 120334 files and directories currently installed.)
Unpacking libftdi1 (from .../libftdi1_0.16-2_i386.deb) ...
Selecting previously deselected package setserial.
Unpacking setserial (from .../setserial_2.17-45_i386.deb) ...
Selecting previously deselected package lirc.
Unpacking lirc (from .../lirc_0.8.6-0ubuntu2_i386.deb) ...
Processing triggers for sreadahead ...
Processing triggers for man-db ...
Processing triggers for doc-base ...
Processing 25 changed 1 added doc-base file(s)...
Registering documents with scrollkeeper...
Processing triggers for hal ...
Regenerating hal fdi cache ...
hal start/running, process 7976
Setting up libftdi1 (0.16-2) ...

Setting up setserial (2.17-45) ...
dpkg: warning: obsolete option '--print-installation-architecture', please use '--print-architecture' instead.
removing the old setserial entry in the rcn.d directories
Update complete.
dpkg: warning: obsolete option '--print-installation-architecture', please use '--print-architecture' instead.
dpkg: warning: obsolete option '--print-installation-architecture', please use '--print-architecture' instead.
Saving state of known serial devices... backing up /var/lib/setserial/autoserial.conf done.

Setting up lirc (0.8.6-0ubuntu2) ...

<---- at this point the lirc configuration text-menu will appear
<---- I selected "custom" for remote control
<---- I selected "custom" for IR Receiver

Processing triggers for libc-bin ...
ldconfig deferred processing now taking place

After lirc was installed.


dpkg -l | grep lirc
ii liblircclient0
ii lirc

(2) Plug in the USB IR unit PCVA-IR3U

Before plug it in, use "dmesg -c" to flush the kernel ring buffer first


# dmesg -c
...
...
...

Plug in the USB IR then run "dmesg -c" again. This will only shows the new devices.


# dmesg -c
[13346.292093] usb 3-2: new low speed USB device using uhci_hcd and address 2
[13346.489338] usb 3-2: configuration #1 chosen from 1 choice
[13346.551449] input: Sony Corporation Sony IR Receiver as /devices/pci0000:00/0000:00:1d.1/usb3/3-2/3-2:1.0/input/input13
[13346.551703] generic-usb 0003:054C:0063.0002: input,hiddev96,hidraw1: USB HID v1.10 Keyboard [Sony Corporation Sony IR Receiver] on usb-0000:00:1d.1-2/input0

(3) check whether /dev/usb/hiddev0 file was created. It should after USB IR was plugged in. If not, maybe try unplug/plug or restart lirc process, using "/etc/init.d/lirc restart" command.

(4) Edit /etc/lirc/hardware.conf file and update the following entries.

#Enable lircd
START_LIRCD="true"

#Chosen Remote Control
REMOTE="Sony USB IR Receiver - or whatever"
REMOTE_MODULES=""
REMOTE_DRIVER=""
REMOTE_DEVICE="/dev/usb/hiddev0"
REMOTE_LIRCD_CONF=""
REMOTE_LIRCD_ARGS=""


# sudo /etc/init.d/lirc start
...

Point RM-GP3 to the receiver and start pressing!

Sorry I will update on how to customize the keys soon...

END

MBSA offline scanning quick start

2009-11-03T13:50:00.011+09:00

Here is the fastest way to get the MBSA offline scanning started

(1) download MBSA 2.1.1 and install on an English XP professional
(2) copy the \Program Files\Microsoft Baseline Security Analyzer 2\mbsacli.exe and wusscan.dll to USB-storage
(3) download the Offline catalog (Wsusscn2.cab) to USB-storage
(4) cd to USB-storage drive, run "mbsacli.exe /xmlout /catalog wsusscn2.cab /nvc > otuput.txt"

Note: I encountered this error messages "An error occurred while scanning for security updates. (0x80247002)" when running above command on a Windows 2003 server just after SP1->SP2 upgrade.
It was resolved by installing WUA standalone installer for x86.

Here is one good reference site http://msdn.microsoft.com/en-us/library/aa302360(printer).aspx

usl-5p openbsd installation log

2009-07-10T02:13:00.004+09:00


SH IPL+g version 0.9, Copyright (C) 2000 Free Software Foundation, Inc.

This software comes with ABSOLUTELY NO WARRANTY; for details type `w'.
This is free software, and you are welcome to redistribute it under
certain conditions; type `l' for details.

2002/09/09 Making.  2004/09/08 I-O DATA NSU Update.
266:133:33 on base clock 22.22MHz and SDRAM 4 burst. CF boot.

PCIC initialization done.
MASTER:48bit LBA mode non support
Disk drive detected:  20071116 CF CARD     CF103C99
LBA: 0078FC60
DiskSize: 4059611136Byte
PIO MODE1
Set Transfer Mode result: 50
> b
Set Transfer Mode result: 50
Initialize Device Parameters result: 50
IDLE result: 50

OpenBSD MBR

OpenBSD/landisk Primary Bootstrap
>> OpenBSD/landisk BOOT 1.01
boot>
booting cf:/bsd: 4105836+365056 [72+92416+82873]=0x46e75c
[ using 175856 bytes of bsd ELF symbol table ]
Copyright (c) 1982, 1986, 1989, 1991, 1993
       The Regents of the University of California.  All rights reserved.
Copyright (c) 1995-2009 OpenBSD. All rights reserved.  http://www.OpenBSD.org

OpenBSD 4.5 (RAMDISK) #129: Tue Mar  3 11:46:47 MST 2009
   deraadt@landisk:/usr/src/sys/arch/landisk/compile/RAMDISK
I-O DATA USL-5P
real mem = 67108864 (64MB)
avail mem = 61136896 (58MB)
mainbus0 at root
cpu0 at mainbus0: HITACHI SH4 266.666 MHz PCLOCK 33.333 MHz
cpu0: 16KB/32B 2-way associative I-cache, 32KB/32B 2-way associative D-cache
shb0 at mainbus0
scif0 at shb0
scif0: console
rsclock0 at shb0: RS5C313 real time clock
shpcic0 at mainbus0: HITACHI SH7751R
pci0 at shpcic0
re0 at pci0 dev 0 function 0 "Realtek 8139" rev 0x20: RTL8139C+ (0x7480), irq 5,
address 00:a0:b0:6c:e7:0c
rlphy0 at re0 phy 0: RTL internal PHY
ohci0 at pci0 dev 2 function 0 "NEC USB" rev 0x43: irq 7, version 1.0
ohci1 at pci0 dev 2 function 1 "NEC USB" rev 0x43: irq 8, version 1.0
ehci0 at pci0 dev 2 function 2 "NEC USB" rev 0x04: irq 5
usb0 at ehci0: USB revision 2.0
uhub0 at usb0 "NEC EHCI root hub" rev 2.00/1.00 addr 1
usb1 at ohci0: USB revision 1.0
uhub1 at usb1 "NEC OHCI root hub" rev 1.00/1.00 addr 1
usb2 at ohci1: USB revision 1.0
uhub2 at usb2 "NEC OHCI root hub" rev 1.00/1.00 addr 1
obio0 at mainbus0
wdc0 at obio0 port 0x14000000-0x1400000f irq 10
wd0 at wdc0 channel 0 drive 0: <>
wd0: 1-sector PIO, LBA, 3871MB, 7928928 sectors
wd0(wdc0:0:0): using BIOS timings
rd0: fixed, 5120 blocks
root on rd0a swap on rd0b dump on rd0b
erase ^?, werase ^W, kill ^U, intr ^C, status ^T
(I)nstall, (U)pgrade or (S)hell? I

Welcome to the OpenBSD/landisk 4.5 install program.

This program will help you install OpenBSD. At any prompt except password
prompts you can escape to a shell by typing '!'. Default answers are shown
in []'s and are selected by pressing RETURN.  At any time you can exit this
program by pressing Control-C, but exiting during an install can leave your
system in an inconsistent state.

Terminal type? [vt220]

IS YOUR DATA BACKED UP? As with anything that modifies disk contents, this
program can cause SIGNIFICANT data loss.

It is often helpful to have the installation notes handy. For complex disk
configurations, relevant disk hardware manuals and a calculator are useful.

Proceed with install? [no] yes
Cool! Let's get to it.

You will now initialize the disk(s) that OpenBSD will use. To enable all
available security features you should configure the disk(s) to allow the
creation of separate filesystems for /, /tmp, /var, /usr, and /home.

Available disks are: wd0.
Which one is the root disk? (or 'done') [wd0]
Do you want to use *all* of wd0 for OpenBSD? [no] yes
Putting all of wd0 into an active OpenBSD MBR partition (type 'A6')...done.

You will now create an OpenBSD disklabel inside the OpenBSD MBR
partition. The disklabel defines how OpenBSD splits up the MBR partition
into OpenBSD partitions in which filesystems and swap space are created.

The offsets used in the disklabel are ABSOLUTE, i.e. relative to the
start of the disk, NOT the start of the OpenBSD MBR partition.

# Inside MBR partition 3: type A6 start 63 size 7928865
Treating sectors 63-7928928 as the OpenBSD portion of the disk.
You can use the 'b' command to change this.

Initial label editor (enter '?' for help at any prompt)
> p g
OpenBSD area: 0.0G-3.8G; size: 3.8G; free: 3.8G
#                size           offset  fstype [fsize bsize  cpg]
 c:             3.8G             0.0G  unused
> a a
offset: [63]
size: [7928865] 3072m
Rounding to cylinder: 6291873
FS type: [4.2BSD]
mount point: [none] /
> a b
offset: [6291936]
size: [1636992] 512m
Rounding to cylinder: 1049328
FS type: [swap]
> a e
offset: [7341264]
size: [587664]
FS type: [4.2BSD]
mount point: [none] /var
> p g
OpenBSD area: 0.0G-3.8G; size: 3.8G; free: 0.0G
#                size           offset  fstype [fsize bsize  cpg]
 a:             3.0G             0.0G  4.2BSD   2048 16384    1 # /
 b:             0.5G             3.0G    swap
 c:             3.8G             0.0G  unused
 e:             0.3G             3.5G  4.2BSD   2048 16384    1 # /var
> w
> q
No label changes.
Mount point for wd0e (301056 KBytes)? (or 'none' or 'done') [/var]
Mount point for wd0e (301056 KBytes)? (or 'none' or 'done') [/var] done
No more disks to initialize.

OpenBSD filesystems:
wd0a /
wd0e /var

The next step *DESTROYS* all existing data on these partitions!
Are you really sure that you're ready to proceed? [no] yes
/dev/rwd0a: 3072.2MB in 6291872 sectors of 512 bytes
16 cylinder groups of 202.47MB, 12958 blocks, 25984 inodes each
newfs: reduced number of fragments per cylinder group from 36728 to 36576 to enl
arge last cylinder group
/dev/rwd0e: 286.9MB in 587664 sectors of 512 bytes
5 cylinder groups of 71.44MB, 4572 blocks, 9216 inodes each
/dev/wd0a on /mnt type ffs (rw, asynchronous, local, ctime=Thu Jul  9 16:28:22 2
009)
/dev/wd0e on /mnt/var type ffs (rw, asynchronous, local, nodev, nosuid, ctime=Th
u Jul  9 16:28:22 2009)

System hostname? (short form, e.g. 'foo') garybsd
Configure the network? [yes]
Available interfaces are: re0.
Which one do you wish to initialize? (or 'done') [re0]
Symbolic (host) name for re0? [garybsd]
The media options for re0 are currently
       media: Ethernet autoselect
Do you want to change the media options? [no]
IPv4 address for re0? (or 'none' or 'dhcp') [dhcp] 192.168.1.140
Netmask? [255.255.255.0]
IPv6 address for re0? (or 'rtsol' or 'none') [none]
No more interfaces to initialize.
DNS domain name? (e.g. 'bar.com') [my.domain] openbsd101
DNS nameserver? (IP address or 'none') [none] 61.122.127.74
Use the nameserver now? [yes]
Default IPv4 route? (IPv4 address, 'dhcp' or 'none') 192.168.1.1
add net default: gateway 192.168.1.1
Edit hosts with ed? [no]
Do you want to do any manual network configuration? [no]
Password for root account? (will not echo)
Password for root account? (again)

Let's install the sets!
Location of sets? (disk ftp http nfs or 'done') [disk] ftp
HTTP/FTP proxy URL? (e.g. 'http://proxy:8080', or 'none') [none]
Display the list of known ftp servers? [no]
Server? (IP address, hostname or 'done') 192.168.1.106
Use active mode ftp? [no]
Server directory? [pub/OpenBSD/4.5/landisk] pub
Login? [anonymous]

Select sets by entering a set name, a file name pattern or 'all'. De-select
sets by prepending a '-' to the set name, file name pattern or 'all'. Selected
sets are labelled '[X]'.

       [X] bsd
       [X] bsd.rd
       [X] base45.tgz
       [X] etc45.tgz
       [X] comp45.tgz
       [X] man45.tgz
Set name? (or 'done') [done]
Ready to install sets? [yes]
Getting bsd ...
100% |**************************************************|  2806 KB    00:00
Getting bsd.rd ...
100% |**************************************************|  4181 KB    00:01
Getting base45.tgz ...
100% |**************************************************| 46987 KB    03:25
Getting etc45.tgz ...
100% |**************************************************|   499 KB    00:08
Getting comp45.tgz ...
100% |**************************************************| 93028 KB    04:23
Getting man45.tgz ...
100% |**************************************************|  8033 KB    00:53
Location of sets? (disk ftp http nfs or 'done') [disk] done
Start sshd(8) by default? [yes]
Start ntpd(8) by default? [no]
Saving configuration files...done.
Generating initial host.random file...done.
What timezone are you in? ('?' for list) [Canada/Mountain] ?
Africa/      Chile/       GB-Eire      Israel       NZ-CHAT      UCT
America/     Cuba         GMT          Jamaica      Navajo       US/
Antarctica/  EET          GMT+0        Japan        PRC          UTC
Arctic/      EST          GMT-0        Kwajalein    PST8PDT      Universal
Asia/        EST5EDT      GMT0         Libya        Pacific/     W-SU
Atlantic/    Egypt        Greenwich    MET          Poland       WET
Australia/   Eire         HST          MST          Portugal     Zulu
Brazil/      Etc/         Hongkong     MST7MDT      ROC          posix/
CET          Europe/      Iceland      Mexico/      ROK          posixrules
CST6CDT      Factory      Indian/      Mideast/     Singapore    right/
Canada/      GB           Iran         NZ           Turkey       zone.tab
What timezone are you in? ('?' for list) [Canada/Mountain] Asia/Tokyo
Setting local timezone to 'Asia/Tokyo'...done.
Making all device nodes...done.
Installing boot block...# Inside MBR partition 3: type A6 start 63 size 7928865
done.

CONGRATULATIONS! Your OpenBSD install has been successfully completed!
To boot the new system, enter halt at the command prompt. Once the
system has halted, reset the machine and boot from the disk.
# halt
syncing disks... done

The operating system has halted.
Please press any key to reboot.


SH IPL+g version 0.9, Copyright (C) 2000 Free Software Foundation, Inc.

This software comes with ABSOLUTELY NO WARRANTY; for details type `w'.
This is free software, and you are welcome to redistribute it under
certain conditions; type `l' for details.

2002/09/09 Making.  2004/09/08 I-O DATA NSU Update.
266:133:33 on base clock 22.22MHz and SDRAM 4 burst. CF boot.

PCIC initialization done.
MASTER:48bit LBA mode non support
Disk drive detected:  20071116 CF CARD     CF103C99
LBA: 0078FC60
DiskSize: 4059611136Byte
PIO MODE1
Set Transfer Mode result: 50
> b
Set Transfer Mode result: 50
Initialize Device Parameters result: 50
IDLE result: 50

OpenBSD MBR

OpenBSD/landisk Primary Bootstrap
>> OpenBSD/landisk BOOT 1.01
boot>
booting cf:/bsd: 2590252+425140 [72+147792+135277]=0x3256d4
[ using 283636 bytes of bsd ELF symbol table ]
Copyright (c) 1982, 1986, 1989, 1991, 1993
       The Regents of the University of California.  All rights reserved.
Copyright (c) 1995-2009 OpenBSD. All rights reserved.  http://www.OpenBSD.org

OpenBSD 4.5 (GENERIC) #213: Tue Mar  3 10:20:57 MST 2009
   deraadt@landisk:/usr/src/sys/arch/landisk/compile/GENERIC
I-O DATA USL-5P
real mem = 67108864 (64MB)
avail mem = 62455808 (59MB)
mainbus0 at root
cpu0 at mainbus0: HITACHI SH4 266.666 MHz PCLOCK 33.333 MHz
cpu0: 16KB/32B 2-way associative I-cache, 32KB/32B 2-way associative D-cache
shb0 at mainbus0
scif0 at shb0
scif0: console
rsclock0 at shb0: RS5C313 real time clock
shpcic0 at mainbus0: HITACHI SH7751R
pci0 at shpcic0
re0 at pci0 dev 0 function 0 "Realtek 8139" rev 0x20: RTL8139C+ (0x7480), irq 5,
address 00:a0:b0:6c:e7:0c
rlphy0 at re0 phy 0: RTL internal PHY
ohci0 at pci0 dev 2 function 0 "NEC USB" rev 0x43: irq 7, version 1.0
ohci1 at pci0 dev 2 function 1 "NEC USB" rev 0x43: irq 8, version 1.0
ehci0 at pci0 dev 2 function 2 "NEC USB" rev 0x04: irq 5
usb0 at ehci0: USB revision 2.0
uhub0 at usb0 "NEC EHCI root hub" rev 2.00/1.00 addr 1
usb1 at ohci0: USB revision 1.0
uhub1 at usb1 "NEC OHCI root hub" rev 1.00/1.00 addr 1
usb2 at ohci1: USB revision 1.0
uhub2 at usb2 "NEC OHCI root hub" rev 1.00/1.00 addr 1
obio0 at mainbus0
wdc0 at obio0 port 0x14000000-0x1400000f irq 10
wd0 at wdc0 channel 0 drive 0: <>
wd0: 1-sector PIO, LBA, 3871MB, 7928928 sectors
wd0(wdc0:0:0): using BIOS timings
power0 at obio0 irq 11
softraid0 at root
root on wd0a swap on wd0b dump on wd0b
Automatic boot in progress: starting file system checks.
/dev/rwd0a: file system is clean; not checking
/dev/rwd0e: file system is clean; not checking
setting tty flags
starting network
starting system logger
starting initial daemons:.
savecore: no core dump
checking quotas: done.
building ps databases: kvm dev.
clearing /tmp
starting pre-securelevel daemons:.
setting kernel security level: kern.securelevel: 0 -> 1
creating runtime link editor directory cache.
preserving editor files.
ssh-keygen: generating new DSA host key... done.
ssh-keygen: generating new RSA host key... done.
ssh-keygen: generating new RSA1 host key... done.
openssl: generating new isakmpd RSA key... done.
starting network daemons: sendmail inetd sshd.
starting local daemons:.
standard daemons: cron.
Fri Jul 10 01:53:10 JST 2009

OpenBSD/landisk (garybsd.openbsd101) (console)

login: root
Password:
OpenBSD 4.5 (GENERIC) #213: Tue Mar  3 10:20:57 MST 2009

Welcome to OpenBSD: The proactively secure Unix-like operating system.

Please use the sendbug(1) utility to report bugs in the system.
Before reporting a bug, please try to reproduce it with the latest
version of the code.  With bug reports, please try to ensure that
enough information to reproduce the problem is enclosed, and if a
known fix for it exists, include that as well.

You have mail.
Terminal type? [unknown] vt220
#

my template

2009-06-30T01:24:00.003+09:00

(1) Using "pre" and "code" html code with detailed style


test

(2) with green black style

END

(3) Using only "pre"


~# beadm list -a
BE/Dataset/Snapshot                  Active Mountpoint Space  Policy Created          
-------------------                  ------ ---------- -----  ------ -------          
newsolaris
   rpool/ROOT/newsolaris             -      -          31.73M static 2009-07-01 16:41 
   rpool/ROOT/newsolaris@backup      -      -          0      static 2009-07-03 03:46 
opensolaris
   rpool/ROOT/opensolaris            NR     /          6.48G  static 2009-06-05 11:46 
   rpool/ROOT/opensolaris@backup     -      -          915.5K static 2009-07-03 03:46 
   rpool/ROOT/opensolaris@install    -      -          1.54G  static 2009-05-15 17:59 
   rpool/ROOT/opensolaris@rename_use -      -          24.12M static 2009-07-01 02:58 

~/myp# cat testcgi.pl 
#!/usr/bin/perl

use CGI qw(:all);

print header("text/plain");
foreach my $param ( param() )
{
 print "$param: . param($param) . "\n";
}

(4) Using only "code"


~/myp# cat testcgi.pl 
#!/usr/bin/perl

use CGI qw(:all);

print header("text/plain");
foreach my $param ( param() )
{
 print "$param: . param($param) . "\n";
}

How to install PostgreSQL on OpenSolaris 2009.06

2009-06-05T16:43:00.015+09:00

Host environemt: OpenSolaris 2009.06 snv_111b X86
Background: PostgresSQL version 83 install (1) SUNWpostgr-83-server, and (2) SUNWpostgr-83-client

(1) login as root to install both packages
pkg install SUNWpostgr-83-server

DOWNLOAD PKGS FILES XFER (MB)
Completed 2/2 238/238 9.25/9.25

PHASE ACTIONS
Install Phase 555/555
PHASE ITEMS
Reading Existing Index 8/8
Indexing Packages 2/2

pkg install SUNWpostgr-83-client
DOWNLOAD PKGS FILES XFER (MB)
Completed 1/1 78/78 1.87/1.87

PHASE ACTIONS
Install Phase 141/141
PHASE ITEMS
Reading Existing Index 8/8
Indexing Packages 1/1

(2) verify package installtion
pkginfo | grep postg
system SUNWpostgr-83-client PostgreSQL client tools
system SUNWpostgr-83-libs PostgreSQL client libraries
system SUNWpostgr-83-server PostgreSQL database server
system SUNWpostgr-83-server-data-root PostgreSQL database server data directories and root components

ls /usr/postgres/8.3/
bin/ etc/ lib/ share/

(3) default user (postgres) environment modification; postgres user was created with default home in / (root) and with default shell of /usr/bin/pfksh.
As I would like set shell defaults for user postgres I will need to create a non-root home. I will create it in /export/home/postgres and then create /export/home/postgres/.profile as below;
cat .profile
PATH=/usr/postgres/8.3/bin:${PATH}
MANPATH=/usr/postgres/8.3/man:${MANPATH}
PGDATA=/var/postgres/data
export PATH MANPATH PGDATA

Then I set the default shell to /bin/bash.

(4) The next step is to decide on a directory to create the database and ensure that the permissions are set correctly.
mkdir /var/postgres/data
chown postgres:postgres /var/postgres/data

(5) Login as 'postgres' user to create a database cluster
pfexec su - postgres
-bash-3.2$ which initdb
/usr/postgres/8.3/bin/initdb
-bash-3.2$ initdb -D /var/postgres/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale en_US.UTF-8.
The default database encoding has accordingly been set to UTF8.
The default text search configuration will be set to "english".

fixing permissions on existing directory /var/postgres/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers/max_fsm_pages ... 32MB/204800
creating configuration files ... ok
creating template1 database in /var/postgres/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.

Success. You can now start the database server using:

postgres -D /var/postgres/data
or
pg_ctl -D /var/postgres/data -l logfile start

################################################

(6) To start PostgresSQL
pg_ctl -D /var/postgres/data -l postmaster.log start

This will start and create /export/home/postgres/postmaster.log file.

(7) To connect the database called ¨postgres¨ running on a default port
psql postgres
Welcome to psql 8.3.7, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

postgres=#

(8) To stop PostgresSQL
pg_ctl stop
waiting for server to shut down.... done
server stopped

cat /export/home/postgres/postmaster.log
LOG: database system was shut down at 2009-06-08 01:01:52 JST
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
LOG: received smart shutdown request
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down

postgreSQL Integration with Solaris Service Management Facilty (SMF)
svcs -a | grep -i postgres
disabled 20:55:33 svc:/application/database/postgresql_83:default_32bit
disabled 20:55:33 svc:/application/database/postgresql_83:default_64bit
... more later