Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgreSQL Installation Types On Linux Example With Screenshot

-
If the database server is remote machine we need to set
1.PGHOST
2.PGPORT
Postgres server Types:
1.Postgresq Server
    • PostgreSQL is an open source relational database management system ( DBMS ) developed by a worldwide team of volunteers
    • Free Of Cost
    2.PPAS - Enterprise Ed
    • Postgres Plus Advanced Server (PPAS)
    • It is cost
    Postgresql Installation Types On Linux:
    I.   GUI
    II.  Text Mode
    III. Unattented Mode

    Comments

    Post a Comment

    Popular posts from this blog

    VMWARE WORKSTATION 3,4,5,6,7,8,9,10,11,12,14,15...etc LICENSE KEYS COLLECTION

    -
    Image
    Below tutorialdba.com collected and sorted out hundreds of universal License Keys for all major versions of VMware Workstation Pro (not for VMware Workstation Player) 4.x, 5.x, 6.x, 7.x, 8.x, 9.x, 10.x, 11.x, 12.x and v14.x on Windows and Linux platforms (support both 32-bit and 64-bit operating system) in this single post. Besides, we also provide some license keys for VMware other projects. Just enjoy and share them. // 4~14 Universal License Keys // Version License Keys VMware Workstation VMware Workstation 4.x.x ZHDH1-UR90N-W844G-4PTN6 G1NP0-T88AL-M016F-4P8N2 ZC14J-4U16A-0A04G-4MEZP J1WF8-58LDE-881DG-4M8Q3 VMware Workstation 5.x.x LUXRM-WP0DN-A256U-4M9Q3 DJXDR-NDT27-Y2NDU-4YTZK DA925-HP80U-Z8HDC-4WXXP 3KW2W-AYR2C-88M6F-4MDQ2 VMware Workstation 6.x.x A0E8R-YUDFV-6AK2F-4GAN2 CRX0D-VWL0V-7CJ6C-46C7A NA8RX-QPNDU-D2LA9-4WAZL 1H4WM-N21FZ-7GK2A-44U5U 6AJ6N-THY2P-42KEF-4WTFG FK8R9-LPCDT-88H4Y-4WRN3 KAR8R-T8MAL-K8J6A-4WDXQ YJEKW-JMFF4-YA1DC-4WTQ...
    Read more

    PostgreSQL DOMAIN Data Type -2

    -
    PRACTICAL 2 .CREATION OF DOMAIN WITHOUT CONSTRAINT: Consider the following scenario on PostgreSQL 9.3: Step 1 .Create a domain with no constraints: postgres=# CREATE DOMAIN zipcode AS text; CREATE DOMAIN Step 2 .Add a named constraint: postgres=# ALTER DOMAIN zipcode ADD CONSTRAINT zipcheck CHECK (char_length(VALUE) = 3); ALTER DOMAIN Step 3 .Check the Domain whether created or not: postgres=# \dD List of domains Schema | Name | Type | Modifier | Check --------+-------------+------+----------+------------------------------------------------------------------ public | postal_code | text | | CHECK (VALUE ~ '^\d{5}$'::text OR VALUE ~ '^\d{5}-\d{4}$'::text) public | zipcode | text | | CHECK (char_length(VALUE) = 3) (2 rows) Step 4 .Ctreate a table using "zipcode" Data type postgres=# create table details (name...
    Read more

    10. Global Sequences

    -
    10.1.  Purpose of global sequences 10.2.  When to use global sequences 10.3.  Using global sequences 10.4.  Listing global sequences 10.5.  Global sequence limitations 10.6.  Global sequence voting 10.7.  Traditional approaches to sequences in distributed DBs 10.7.1.  Step/offset sequences 10.7.2.  Composite keys 10.7.3.  UUIDs BDR  global sequences provide an easy way for applications to use the database to generate unique synthetic keys in an asynchronous distributed system. Global sequences should be considered deprecated. See  When to use global sequences  and  Global Sequence Limitations . Most deployments are better off using step/offset sequences as described 
    Read more

    Oracle to Postgresql migration

    -
    Oracle migration: For migration first we need to install oracle database and ora2pg software and DBD oracle packages. =>first install oracle database in server and note down the paths,username,password needed For installing the oracle database follow the below steps: From the root user: create group "groupadd oinstall" create group "dba" create user "useradd oracle -G dba -g oinstall create directory "mkdir /home/oracle/software" Change ownership permissions to software directory chown oracle:oinstall /home/oracle/software copy the downloaded files to /home/oracle/software and untar the files After untaring we can find "database" directory in /home/oracle/software In database directory we find runinstaller file we need to run that file ./runinstaller and finish the oracle database installation. ======================================================================= After finishing the installation switch to oracle use...
    Read more

    How to Configure Oracle Dataguard and How to Perform Switchover and Failover

    -
    Answer: In this article i will explained about how to configure oracle dataguard without using Rman utility and also explained what type of errors you will be faced at the time of configuring oracle dataguard and also i gave some real time interview questions and answer related to oracle dataguard   Before Dataguard configure you need to perform some postrequest oracle version and os version should be same. Ping the both server from primary to standby and standby to primary ( ping 192.168.1.100) check fairewal;l status if enaled or not using service iptables status check the port number whether available or not using netstat -plunts |grep port_number Primary database : nijam                       standby database : benz       server : 192.168.1.100               ...
    Read more