MIRCX IRC Network
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Search
 
 

Display results as :
 


Rechercher Advanced Search

Web Applications
install Joomla Wordpress Phpbb Drupal FluxBB PunBB osCommerce simple-machines MYBB moodle vBulletin Dolphin-v.7.1.1 PHPNUKE XOOPS
Services
install BorkNet Services X3 Services Anope Atheme Services Srvx IRC Srervices
IRCD
install Snircd IRCU INSPIRCD UNREAL Nefarious Bircd Bahamut Asuka Charybdis
TCL SCRIPT
TCL SCRIPT FOR EGGDROP Allprotection4.7 Antiproxy
Bots
Bots install FishBot bobot++ Eggdrop janus Omega Security Services Botnix Bopm SupyBot PyLink Hopm
Latest topics
» מדריך גירסה INSPIRCD V4
install - Guide install postgresql on ubuntu EmptySat Aug 05, 2023 2:09 am by Chief

» mIRCx IRC Network Config
install - Guide install postgresql on ubuntu EmptySat Jul 15, 2023 9:51 pm by Chief

» ircu2.10.12-pk with dnsbl
install - Guide install postgresql on ubuntu EmptyFri Mar 10, 2023 2:22 pm by Admin

» Guide install PyLink on New version FreeBSD
install - Guide install postgresql on ubuntu EmptyThu Dec 15, 2022 9:39 pm by Chief

» מדריך התקנה PBot על מערכת הפעלה FreeBsd-12
install - Guide install postgresql on ubuntu EmptyMon Dec 05, 2022 5:44 am by Chief

» install Nefarious2 && X3 IRC Services in FreeBsd
install - Guide install postgresql on ubuntu EmptySat Nov 12, 2022 3:12 pm by Chief

» help problem with adduser in Freebsd 12
install - Guide install postgresql on ubuntu EmptyFri Nov 11, 2022 9:06 pm by Chief

» מדריך פקודות והתקנה בסרביס X3
install - Guide install postgresql on ubuntu EmptyFri Oct 28, 2022 1:43 pm by Chief

» מדריך הגדרות WebIRC in Nefarious2
install - Guide install postgresql on ubuntu EmptyThu Apr 07, 2022 4:45 am by Chief

March 2024
MonTueWedThuFriSatSun
    123
45678910
11121314151617
18192021222324
25262728293031

Calendar Calendar

Affiliates
free forum

Affiliates
free forum


Guide install postgresql on ubuntu

Go down

install - Guide install postgresql on ubuntu Empty Guide install postgresql on ubuntu

Post  Chief Wed Nov 20, 2013 12:02 am

Guide install postgresql on ubuntu
ok before i start with my guide i go to explain how we can install postgresql on ubuntu and create name database and create TABLE
i epxlain slow slow and step by step.........
step1
we need inside to Terminal and write like this
install - Guide install postgresql on ubuntu 118
this the commands you need to install
Code:

sudo apt-get install postgresql postgresql-client postgresql-common
step2
after you install postgresql in your system then now you need also create database and you need doing like this
install - Guide install postgresql on ubuntu 214
if  you see you have two commands and it this
Code:

sudo su postgres
psql
afther you write two commands you can see you inside to options create new Database this look like this
install - Guide install postgresql on ubuntu 315
like you see this commands for Create New database
Code:

CREATE DATABASE mircx;
for look list of Databases you can write like this
install - Guide install postgresql on ubuntu 415
step3
you can also create TABLE nember if you dont know how this working then its look like this
install - Guide install postgresql on ubuntu 514
this mean you can copy this and put your name psql
Code:

psql mircx
CREATE TABLE member (
name varchar(80),
last varchar(80),
birthdate date
);
step4
you can CREATE in you psql  Separate Roles you can see in here all options what you have
install - Guide install postgresql on ubuntu 613
the commands for create you can write like this
install - Guide install postgresql on ubuntu 712
Code:

CREATE ROLE login_mircx WITH login;
\du
after you doing this you can see in picture your create roles
install - Guide install postgresql on ubuntu 814
step5
if you want create password you need make like this
install - Guide install postgresql on ubuntu 912
Code:

sudo -u postgres psql mircx
\password postgres
more something important if you want remove your database what you Create then you need doing like this
install - Guide install postgresql on ubuntu 1112
Code:

dropdb mircx
for question
mircx123@gmail.com
Good luck
Guide By MIRCX
The community old
Chief
Chief
Admin

מספר הודעות : 268
Join date : 2011-12-09
מיקום : mIRCx IRC Network

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum