| Elements | Orcale | PostgreSQL |
| Integer Number | number(), integer, int, long | int |
| Real Number | real | float |
| Character | charcter, char() fixed 255bytes, nchar() | char |
| String | varchar2() variable 4000bytes, nchar() | text |
| Date | date | date |
| Logical | boolean | bool |
| Order | ? | Serial |
| File SQL | @file | \i file |
set path = ($path /usr/local/pgsql/bin) setenv POSTGRES_HOME /usr/local/pgsql setenv PGLIB $POSTGRES_HOME/lib setenv PGDATA $POSTGRES_HOME/data setenv MANPATH "$MANPATH":$POSTGRES_HOME/man setenv LD_LIBRARY_PATH "$PGLIB"
IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, size=1115136, permission=600 This type of error is usually caused by an improper shared memory or System V IPC semaphore configuration. For more information, see the FAQ and platform-specific FAQ's in the source directory pgsql/doc or on our web site at http://www.postgresql.org. FATAL 1: ShmemCreate: cannot create region
| OS | Orignail RedHat RPM | Manual Install |
| path | export PATH=/usr/bin:$PATH | export PATH=/usr/local/pgsql/bin:$PATH |
| HOME | export POSTGRES_HOME=/var/lib/pgsql | export POSTGRES_HOME=/usr/local/pgsql |
| PGDATA | export PGDATA=/var/lib/pgsql/data | export PGDATA=/usr/local/pgsql/data export PGDATA=/var/lib/pgsql/data |
| PGLIB | export PGLIB=/var/lib/pgsql/lib | export PGLIB=/usr/local/pgsql/lib |
| MANPATH | export MANPATH="$MANPATH" | export MANPATH="$MANPATH":$POSTGRES_HOME/man |
| LIB | export LD_LIBRARY_PATH="$PGLIB" | export LD_LIBRARY_PATH="$PGLIB" |
| start script | /etc/init.d/postgresql | cp $Install/contrib/startup-scripts/linux /etc/init.d/postgresql /etc/init.d/postgresql |
| CONF | /var/lib/pgsql/data/*.conf | /usr/local/pgsql/data/*.conf /var/lib/pgsql/data/*.conf |
| LOG | /var/lib/pgsql/data/*.log | /usr/local/pgsql/data/*.log /var/lib/pgsql/data/*.log |
|
35: #PGDATA='/usr/local/pgsql/data' 36: PGDATA='/var/lib/pgsql/data' |
-----------+----------+------------------ template0 | postgres | SQL_ASCII template1 | postgres | SQL_ASCII mydb | user1 | UNICODE mydb2 | user1 | EUC_JP
|
export PATH=/usr/local/pgsql/bin:$PATH export POSTGRES_HOME=/usr/local/pgsql export PGLIB=$POSTGRES_HOME/lib export PGDATA=/var/lib/pgsql/data #export MANPATH=$MANPATH:$POSTGRES_HOME/man export LD_LIBRARY_PATH=$PGLIB |
| local | all | trust | |||
| #host | all | 127.0.0.1 | 255.255.255.255 | md5 | user |
| #host | dbname | 123.234.123.0 | 255.255.255.128 | trust |
tcpip_socket = true |
|
export CYGWIN=server export PATH=$PATH:/usr/sbin export PGLIB=/usr/local/pgsql/lib export PGDATA=/usr/local/pgsql/data export PGHOST=127.0.0.1 |
Message Queues: T ID KEY MODE OWNER GROUP Shared Memory: T ID KEY MODE OWNER GROUP Semaphores: T ID KEY MODE OWNER GROUP
NG: initdb: removing data directory "/var/lib/pgsql/data"
Please check above setting values.
NG: /usr/bin/postgres could not locate postgres execution.
ls -l /usr/bin/postgres
chmod 755 /usr/bin/postgres
-----------+----------+------------------ template0 | postgres | SQL_ASCII template1 | postgres | SQL_ASCII
User name | User ID | Attrubutes --------------+----------+------------------ administrator | 100 | superuser, create database postgres | 1 | superuser, create database
| select version(); |
psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?
Name | Owner | Encoding | -----------+----------+----------+ mydb | myname | UTF8 | postgres | postgres | UTF8 | template0 | postgres | UTF8 | template1 | postgres | UTF8 |
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock default-character-set=utf8 : [client] default-character-set=utf8
Server version: 5.0.67 Server characterset: latin1(utf8 by /etc/my.cnf) Db characterset: latin1(utf8 by /etc/my.cnf) Client characterset: latin1(utf8 by /etc/my.cnf) Conn. characterset: latin1(utf8 by /etc/my.cnf)
| DB | Oracle | PostgreSQL | MySQL |
| shell command | sqlplus | psql | mysql |
| all tables | ? | \dt | show tables; |
| table | desc tbl | \d tbl | desc tbl; |
| Password | SET PASSWORD=PASSWORD('new_password') | ||
| file | @file | \i file | source file.sql |
| sequence | id number(15) create seaquence |
id serial not null | id integer NOT NULL AUTO_INCREMENT PRIMARY KEY |
| table | ? | \copy tbl_name from '/path/data.csv' using delimiters ','; | load data local infile "/path/data.csv" into table tbl_name fields terminated by '\t'; NULL='\N' |
| csv | select * from mytbl into outfile "/tmp/dump.csv" fields terminated by '\t'; | ||
| end | exit quit | \q | exit |
| dump | pg_dump mydb -f mydb.out | mysqldump file.sql |