Recent Notes
Displaying keyword search results 81 - 90
Created by voodoo on July 12, 2010 18:29:05
Last update: July 12, 2010 18:29:22
Use the \l command to list all databases:
postgres=# \l
...
Created by voodoo on July 12, 2010 18:26:19
Last update: July 12, 2010 18:26:19
Use the \i command to run a SQL script file:
postgres=# \i /usr/share/pgsql/contrib/pgcrypto.sq...
Created by voodoo on July 09, 2010 21:02:35
Last update: July 09, 2010 21:02:35
The rpm command tells you where a package is installed:
[root@bamboo ~]# rpm -ql postgresql-jdbc
/etc/m...
Created by voodoo on July 01, 2010 16:57:31
Last update: July 01, 2010 16:57:31
Use the pg_ctl command to start/stop/restart the PostgreSQL server:
$ bin/pg_ctl -D /usr/local/pgsql/data -l logs/post...
Environment variable PGDATA can be set in lieu of the -D switch.
Created by magnum on June 23, 2010 20:42:12
Last update: June 23, 2010 20:52:33
Compile mod_proxy_html from source code.
Prerequisite: Apache httpd installed on system with header files.
Command:
# /usr/local/apache2/bin/apxs -i -c -I/usr/local/i...
Output:
/usr/local/apache2/build/libtool --silent --mode=c...
Created by voodoo on June 17, 2010 22:01:21
Last update: June 17, 2010 22:02:33
I'm building PostgreSQL 8.4.4 on Solaris 10 and got this ar: Command not found error:
ar crs libpgport.a isinf.o getopt.o chklocale.o co...
It turned out that the ar command is under the directory /usr/ccs/bin , adding it to the PATH solves the problem:
PATH=/usr/ccs/bin:$PATH
Created by voodoo on June 17, 2010 16:02:07
Last update: June 17, 2010 16:03:05
Use the uname command to display the SunOS version:
$ uname -a
SunOS STAWOW1 5.10 Generic_142900-01...
I can't find a command to display Solaris version. But the /etc/release file gives version information:
$ cat /etc/release
Solar...
This is a mapping of SunOS versions to Solaris versions:
SunOS Version Solaris Version
SunOS 5.4 Solaris 2.4
SunOS 5.5 Solaris 2.5
SunOS 5.5.1 Solaris 2.5.1
SunOS 5.6 Solaris 2.6
SunOS 5.7 Solaris 7
SunOS 5.8 Solaris 8
SunOS 5.9 Solaris 9
SunOS 5.10 Solaris 10
Reference:
SUN Solaris Unix Commands and Scripts
Created by voodoo on June 17, 2010 15:23:02
Last update: June 17, 2010 15:35:40
Use useradd to add a user (the switches are not required, but it's a good idea to give them. For example, without -m you'd create a user without a home directory):
# -d switch specifies user home directory
# -m ...
You also need to use the passwd command to set a new password before the user can log in.
To delete a user, use the userdel command:
userdel demo
Created by voodoo on June 17, 2010 15:32:12
Last update: June 17, 2010 15:32:12
Use the passwd command to set the password for a user:
passwd demo
Created by Dr. Xi on June 11, 2010 19:04:18
Last update: June 11, 2010 19:06:35
The caret ^ is DOS command line escape character.
Example 1: echo < and > as is, not interpreting them as input/output redirect.
@rem sign an XML file. Requires Java class utils.x...
Example 2: treat & literally, not as the special character to combine two commands.
@rem search "dos command line" in Google.
curl ...
Add switch -A "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1" to make curl look like Firefox.
