Щось корисне про IT

$ /usr/local/pgsql/bin/psql postgres postgres
Password: (oldpassword)
ALTER USER postgres WITH PASSWORD ‘tmppassword’;
$ /usr/local/pgsql/bin/psql postgres postgres
Password: (tmppassword)

$ /usr/local/pgsql/bin/psql postgres postgres Password: (oldpassword) ALTER USER postgres WITH PASSWORD ‘tmppassword’; $ /usr/local/pgsql/bin/psql postgres postgres Password: (tmppassword)

ALTER USER username WITH PASSWORD ‘tmppassword’;

ALTER USER username WITH PASSWORD ‘tmppassword’;

$ su - root
# tar xvfz postgresql-8.3.7.tar.gz
# cd postgresql-8.3.7
# cp contrib/start-scripts/linux /etc/rc.d/init.d/postgresql
# chmod a+x /etc/rc.d/init.d/postgresql

$ su - root # tar xvfz postgresql-8.3.7.tar.gz # cd postgresql-8.3.7 # cp contrib/start-scripts/linux /etc/rc.d/init.d/postgresql # chmod a+x /etc/rc.d/init.d/postgresql

$ /etc/init.d/postgresql status 
Password:
pg_ctl: server is running (PID: 6171)
/usr/local/pgsql/bin/postgres “-D” “/usr/local/pgsql/data”

$ /etc/init.d/postgresql status Password: pg_ctl: server is running (PID: 6171) /usr/local/pgsql/bin/postgres “-D” “/usr/local/pgsql/data”

$ /etc/init.d/postgresql status
Password:
pg_ctl: no server running

$ /etc/init.d/postgresql status Password: pg_ctl: no server running

# service postgresql stopStopping PostgreSQL: server stopped
ok
# service postgresql start
Starting PostgreSQL: ok
# service postgresql restart
Restarting PostgreSQL: server stopped
ok

# service postgresql stopStopping PostgreSQL: server stopped ok # service postgresql start Starting PostgreSQL: ok # service postgresql restart Restarting PostgreSQL: server stopped ok

$ /usr/local/pgsql/bin/psql testWelcome 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
test=# select version();
version
—————————————————————————————————-
PostgreSQL 8.3.7 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20071124 (Red Hat 4.1.2-42)
(1 row)
test=#

$ /usr/local/pgsql/bin/psql testWelcome 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 test=# select version(); version —————————————————————————————————- PostgreSQL 8.3.7 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20071124 (Red Hat 4.1.2-42) (1 row) test=#

CREATE USER ramesh WITH password ‘tmppassword’;CREATE ROLE

CREATE USER ramesh WITH password ‘tmppassword’;CREATE ROLE

$ /usr/local/pgsql/bin/createuser sathiyaShall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) n
Shall the new role be allowed to create more new roles? (y/n) n
CREATE ROLE

$ /usr/local/pgsql/bin/createuser sathiyaShall the new role be a superuser? (y/n) n Shall the new role be allowed to create databases? (y/n) n Shall the new role be allowed to create more new roles? (y/n) n CREATE ROLE

CREATE DATABASE mydb WITH OWNER ramesh;CREATE DATABASE

CREATE DATABASE mydb WITH OWNER ramesh;CREATE DATABASE

$ /usr/local/pgsql/bin/createdb mydb -O ramesh
CREATE DATABASE

$ /usr/local/pgsql/bin/createdb mydb -O ramesh CREATE DATABASE

# \l
List of databases
Name | Owner | Encoding
———-+———-+———-
backup | postgres | UTF8
mydb | ramesh | UTF8
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8

# \l List of databases Name | Owner | Encoding ———-+———-+———- backup | postgres | UTF8 mydb | ramesh | UTF8 postgres | postgres | UTF8 template0 | postgres | UTF8 template1 | postgres | UTF8

# \lList of databases
Name | Owner | Encoding
———-+———-+———-
backup | postgres | UTF8
mydb | ramesh | UTF8
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8

# \lList of databases Name | Owner | Encoding ———-+———-+———- backup | postgres | UTF8 mydb | ramesh | UTF8 postgres | postgres | UTF8 template0 | postgres | UTF8 template1 | postgres | UTF8

DROP DATABASE mydb;
#DROP DATABASE

DROP DATABASE mydb; #DROP DATABASE

# \?
# \h CREATE
# \h CREATE INDEX

# \? # \h CREATE # \h CREATE INDEX

# \d

# \d

# \timingTiming IS ON.
SELECT * FROM pg_catalog.pg_attribute ;
TIME: 9.583 ms

# \timingTiming is on. SELECT * from pg_catalog.pg_attribute ; Time: 9.583 ms

# \df
# \df+

# \df # \df+

# \e

# \e

$ cat ~/.psql_historyalter USER postgres WITH password ‘tmppassword’;
\h ALTER USER
SELECT version();
CREATE USER ramesh WITH password ‘tmppassword’;
\timing
SELECT * FROM pg_catalog.pg_attribute;

$ cat ~/.psql_historyalter user postgres with password ‘tmppassword’; \h alter user select version(); create user ramesh with password ‘tmppassword’; \timing select * from pg_catalog.pg_attribute;