From suresh.g@zensar.com Wed Jan 30 06:39:15 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4C4212E007F; Wed, 30 Jan 2008 02:39:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 17992-02; Wed, 30 Jan 2008 02:39:09 -0400 (AST) Received: from mailrelay.zensar.com (mailrelay.zensar.com [203.124.143.173]) by postgresql.org (Postfix) with ESMTP id 0B1572E004C; Wed, 30 Jan 2008 02:39:06 -0400 (AST) Received: from BRIDGEHEAD.ind.zensar.com ([10.42.2.95]) by mailrelay.zensar.com with Microsoft SMTPSVC(6.0.3790.3959); Wed, 30 Jan 2008 12:09:30 +0530 Content-Transfer-Encoding: 7bit Received: from ZENMAILHQ1.ind.zensar.com ([10.42.2.82]) by BRIDGEHEAD.ind.zensar.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 30 Jan 2008 12:08:36 +0530 Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.3959 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/related; type="multipart/alternative"; boundary="----_=_NextPart_001_01C8630A.BD59C087" Subject: Can we have 2 databases on same server Date: Wed, 30 Jan 2008 12:08:34 +0530 Message-ID: <3D5445983859B84B92669C0D883EA6FB0C0A57B5@ZENMAILHQ1.ind.zensar.com> X-MS-Has-Attach: yes X-MS-TNEF-Correlator: Thread-Topic: Can we have 2 databases on same server Thread-Index: Achi/3llDifcyTUSST2axBfhDjP0DQAChziQ From: "Suresh Gupta VG" To: , X-OriginalArrivalTime: 30 Jan 2008 06:38:36.0556 (UTC) FILETIME=[BDD254C0:01C8630A] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.141 tagged_above=0 required=5 tests=AWL=-0.861, BAYES_50=0.001, EXTRA_MPART_TYPE=1, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200801/280 X-Sequence-Number: 28054 This is a multi-part message in MIME format. ------_=_NextPart_001_01C8630A.BD59C087 Content-Type: multipart/alternative; boundary="----_=_NextPart_002_01C8630A.BD59C087" ------_=_NextPart_002_01C8630A.BD59C087 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi Team, =20 I have Solaris 9 machine with Pgsql 7.4 and want to upgrade to 8.2.5. I don't want to disturb the first version now. I want to install second one separately and need to test with my application. If it works fine, I will activate only the latest one and other version 7.4 will be discarded. This is my idea. =20 1) Can I please know, if we can run 2 databases on the same server with out any conflicts? 2) If it is so, at what stage we are need to configure the 2 databases? Pls provide links or docs if available. 3) If we had a front end application and have the options like switching the database, the 2 databases are compulsory, right?(Thinking only one server is available.)=20 =20 Can you pls advice on this. =20 Regards, G. V. Suresh Gupta ------------------------------------------------------------------------ --------------------------------------------------------- Innovative Technology Solutions(ITS), Zensar Technologies=20 Zensar Knowledge Park, Plot#5, MIDC IT Tower,=20 Kharadi, Off Nagar Road, Pune - 411014 Landline : +91-20-66453471 | +91-9890898688 =20 Email : suresh.g@zensar.com | website: www.zensar.com =20 =20 =20 =20 =20 =20 =20 =20 DISCLAIMER: This email may contain confidential or privileged information for the = intended recipient(s) and the views expressed in the same are not = necessarily the views of Zensar Technologies Ltd. If you are not the = intended recipient or have received this e-mail by error, its use is = strictly prohibited, please delete the e-mail and notify the sender. = Zensar Technologies Ltd. does not accept any liability for virus = infected mails.=20 ------_=_NextPart_002_01C8630A.BD59C087 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi = Team,

 

I have Solaris 9 machine with Pgsql = 7.4 and want to upgrade to 8.2.5. I don’t want to disturb the first = version now. I want to install second one separately and need to test with my application. If it works fine, I will activate only the latest one and = other version 7.4 will be discarded. This is my = idea.

 

1)       = Can I please know, if we can run 2 databases on the same = server with out any conflicts?

2)       = If it is so, at what stage we are need to configure the 2 databases? Pls provide links or docs if = available.

3)       = If we had a front end application and have the options like = switching the database, the 2 databases are compulsory, right?(Thinking only one = server is available.)

 =

Can you pls advice on this.

 

Regards,

G. V. Suresh Gupta

-----------------= -------------------------------------------------------------------------= ---------------------------------------

Innovative Technology Solutions(ITS), Zensar = Technologies

Zensar Knowledge = Park, Plot#5, MIDC IT Tower,

Kharadi, Off Nagar Road, = Pune – 411014

Landline :  = +91-20-66453471         &nbs= p; | = +91-9890898688          = ;      

Email  =    :   suresh.g@zensar.com  &n= bsp; | website:  www.zensar.com

 

 

 

 

=

 

           = ;

DISCLAIMER:
This email may contain confidential or = privileged information for the intended recipient(s) and the views = expressed in the same are not necessarily the views of Zensar = Technologies Ltd. If you are not the intended recipient or have received = this e-mail by error, its use is strictly prohibited, please delete the = e-mail and notify the sender. Zensar Technologies Ltd. does not accept = any liability for virus infected mails. ------_=_NextPart_002_01C8630A.BD59C087-- ------_=_NextPart_001_01C8630A.BD59C087 Content-Type: image/jpeg; name="image001.jpg" Content-Transfer-Encoding: base64 Content-ID: Content-Description: image001.jpg Content-Location: image001.jpg /9j/4AAQSkZJRgABAgAAZABkAAD/7AARRHVja3kAAQAEAAAAPAAA/+4ADkFkb2JlAGTAAAAAAf/b AIQABgQEBAUEBgUFBgkGBQYJCwgGBggLDAoKCwoKDBAMDAwMDAwQDA4PEA8ODBMTFBQTExwbGxsc Hx8fHx8fHx8fHwEHBwcNDA0YEBAYGhURFRofHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f Hx8fHx8fHx8fHx8fHx8fHx8f/8AAEQgAZAB9AwERAAIRAQMRAf/EAJMAAQABBQEBAAAAAAAAAAAA AAADAQIEBgcFCAEBAAMBAQEAAAAAAAAAAAAAAAIDBAEFBhAAAgEDAwMDAwIEBAcAAAAAAQIDAAQF ERIGIRMHMUEiURQIYTJxgSMVkUJSFqGCM2MkhBgRAQACAgEDAQYFBQAAAAAAAAABAhEDITESBEFR YYETFAXwcZGhMrHB4SJS/9oADAMBAAIRAxEAPwD6poFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoF AoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFB5mb5NgMHD3svkILFCNVEz hXf9ET9zn9FFQveK9ZaPH8TbunGus2/L+/sWY/Mz5VVmsbaSOwcbkvLlGhZx0I2QOFk0Ovq+3+Br tbZ6O7dEasxaY7vZHP6z0/TL1gNBp6/qakzFAoFBpHmDyXH474kudNol9LLdw2cFtJL2FZ5dzE7w kn7UjY/tq3Tq77YRtOIcZj/MnISa9vils+nrtyTnTX/1a1/Q+9V873OieGfNmV8i5jJWcuBixlpj beOaS5S6a4JkmcrHHtMMWmqxuddfaqN+iNfqnS/c6xvXdt1G71269f8ACsyxWgoXRSAxALHRQTpq f0oOZeWfO2C8f3EWNWzky+emjE4sI3EMcUTMVV55ir7d21tqqrMdOoA61fp8edn5IXvFXKv/AKx5 4kQyMvErY4gkkTg3gjIB0Olz2jEfprpWr6OnTPKHzJfQONzGU5BwG1zNkseKyeWxkd3aCVu9Hby3 MAkj3sVXeELjU7f5V52ysxmI6tWi1IvWbxmmYzjrj1cut/FflrPrpneX9uzbQOkNxNcAj3/pxi2i /wAdawfTbbfyt+P2fXz98+36udOnNvfER+/+0t/4h4l4dxhkuoLY32UTr/c70iaYH6x6jbH/AMgB +pNaNXj0rzjMvD8/735Hk8TPbT/mvEfH2/FuSyRl2jDAyKAWTUagH01H66Ve8hdQKBQKDSvJvlfj Hj/GCfJObnKTqTjsPCR352HTU69I4wf3SN0HtubRTZq1TecQja0Q+aY7fyp525Ussh7WLtnKd7a6 4zHR6AsqDoZ7hgR7721GpSP09HNNFff/AF/wo5vPue55bit/E+Ix/BeG3E1neZmI5Dk2cDbL66SJ u3BEJlIMUe7f8I9NANAfk+6GiPmz3W9OISvPbGIcnu7PhsfHsXNjIcueYicy5W6lhCWfbYMy/avG Wm3o2zRz+75N/pA0xMzac47Vfp6vS8p8ivc/Lx66y7Pc5Gy43Yw3kkpbfJKxmn3Nr13vHLGWJ9T1 qOivbE46ZL2zMLfLXF5eNclGJyGSfMX9ljLNrmWVdn2zmI7bWAbm2xxIq7NNPX+dd0Wi1c4xyXiY nGXTPIvgTyPmBjOTY8DOXl7isbFmLaWdY7tbq3tEhlfWcqkgfZuOrhtxPQ1n1eVWM16RmcJ31TPL WMN5v8u8AuUw2Skaa1wqJBNx/KQRo6QogKxrNGqzL/S07bFnXTQ6MKst4+u8Zj1RrstE4ltfm7N+ KuT84tIMlLnstdWlnBZW+BwUVuEiupHaV43eYydycrIiskCHaV2k66gU+PW9a8Y+Ky8xMuZ4eKfA +UMfb8PXJ4W4OSsbW2t8oFtr5WnkhV4LxIdiMjM56MPkhGorTbFtebY+CuP5cK5e5y2Y8xX+R46p vM1c8hnkwbABtZIrphavo/w2osauS3xAGp6V2sRGvFumOXJmZtw+nPBXibP8DGfu+QX8GRy2dmgl nuYZJpmbtK5ZpZZ1R3dpJnJb3/4V5nkbYvjtjEQ0UrMdXVqoTKBQKDh/mjwRynn3MYc3YZOxs7WC wiskhuFmZyUlllZvh0690D+Va/H8iKVxMKr6+6Wht+InOmAU8hxwUEkKFugAT6nQECtH11fYh8ls dz+KVxccIxlgMxBByfHS3by3YjeW1uIrmTcsThisqmMKu1hrp8hodQRVHmYtn0SnVGMJMR4Z/Ie2 xcGBPkKHG4OBBBCtn3ZZooR0CxSNFBKoVeiju9PQaVy+7VPMV5drW0dZW8w/GzlvJ/Id/wAkvMxY DH3+QinkttkxlFpCY41j1/bv7EQH01pr8qK07YjktrzOZV5/+NvK+XeQMnyOXLWEdhkbmFmtis3d FtDHHDs1A27jHF/DWmryorTHq5bXmcoM9+PflscmzOV41zCOxt8xfXN88UdzkLAg3MrSbWW3Mitt Dbdf0rtPJp2xFo6E0tnhJxD8UrpMzDlea5xMmEmE9xYW6SSfcurBh9xc3DF3UkfNdmrDpups8zjF YwRq5zKFvxn55j/ID5/jnKLWwtzeT3dtkHidr2AXTOZF7JDQSkJKyallDD2HpXfq6zTtmD5c5zCf jv4z8oxnkK25Le5u1yNraX8uQTv95ruaRd72zzyEbWfu9tpNP109q5by4muIgjVzlL4m/G3kvDuc YrkWUy1ldwY1J9IbdZhI0s0DQa6uNNNJWJrm7yotXBXXicvoOsS4oFAoFB4UvGoH5nbch7FvuhsZ rVpSv9fuPJGUIOnoqK6666/LT0JoMXBccv7Dl2eytwkLwZN0e2nVkMqosMMfbYGBZQN0bHTvsvpo o16BThnHb/Dz5Jr23tu7cSs5yUMsjzXgaeaVXuI2RFRkSVVGjN/pGiqooI+EcVzeCh25DIm/f+24 +zVnYN25rRZRKE2xQ6x6yLtZ90h/zH0oMXhPDM/g8Rf4y6vkCta21nibiKSWaSBIrUI24yqm7t3D yds66mMJu6g0FvHeGZix4tm8W4t7GXIwmK1traaWWCKT7Rbd5u46o4aaVTI2i6/5jq5Y0HqZjD5n J8QisJIYFvla1a5smneS3mjt7hJJbd5u2jMk8UZRtY9Du0YFdQQwp+I5VuFWmFJgnlguI5prF5JP tntxcmb7LuMrO0UUREabk0cIAy7SRQS3PG8vPw3C4q4hspcjZTYuW7VGkjtV+yuIpp+xuSV9NsTK itp66EgUEuZ43f3fNMRmkSGazsYZIpEkZA6O7qwkRXgn9FU9Ukjb6kj0B/t3Jjn4zsYhFibQW8zS SGWU6akCFDGrQfIjdpMyN69sP86DZ6BQKBQKDEmy+OguHt5pxHLHH3pA4KhYgGJkZiNoQbTq2ugP T1IoJGvrFAS9xEoGmpLqP3bQvv7710/iPrQR/wB1sRdy2jyGOaHthjIjohMx0jCyMAjlj0AUnr0o Lv7pjfj/AOXD8w7J/UT5LFqJCOvUJp8vpQRRZvFyXEkC3Ee6N449xZQrSTJ3ERDr8mKaN09qCRcr jGkjjW8gMkv/AEkEibm0Yqdo16/JSOnvQWjMYxpFjjuY5ZHVXVI2ViUeTtBxof27+mtBJHkcfI0S x3MTtOXEAV1JcxEiQJoflsI+WnpQR22Xx1yzLFMA6yvBscGNjJGNzBQ4UsNvXVemnWgR5nEyNtS8 gY7o0Gki9WmXfEo69S69V09aCZL2zeRY0njaRy6qgdSSYjpIAAfVD0b6UE1AoFAoFBg3+Htb2XvO zpMsfbjlTbuTSRJVYblYaq8anQ6j6g0GPDxmwhkDK8pRRAEiYqVU25jKkfHXU9hNdT7dNKDJmxFp Nd/dPuMm6Jwuo26wb9nQj/uGgw4eK46OFYmeSbaJAXm2SFu8JA+/chVte82uo6++tBIvHLQLCO9O Whkjk3swZn7SRpo7MpJ3dlSx9dffrQBxvHB7dxv3WqRJGfj6QvvXX4+u71oKW3GrO3ihjWaZxEQS XZSXYXAuQznaOvcB9PYnX2NBW043Y2xt2V5He2OsbuV1PQIAdqr0CKq9Pp11OpoKf7Zx4MOxpIxF NNcsqFQJJZySzyfH5MNdAfXTpQXDjtiAihpAkbRPGnx0VoY+0pHx91A1/h0060F+PwNhYSrLAG3J 3guu30nZGYEgAnTtKAT109daD0aBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKB QKBQKBQKBQKBQKBQKBQKBQKBQKD/2Q== ------_=_NextPart_001_01C8630A.BD59C087-- From dmagick@gmail.com Wed Jan 30 06:59:56 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3F6BC2E0077 for ; Wed, 30 Jan 2008 02:59:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 31242-06 for ; Wed, 30 Jan 2008 02:59:47 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.179]) by postgresql.org (Postfix) with ESMTP id B066D2E0082 for ; Wed, 30 Jan 2008 02:59:47 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so243238waf.5 for ; Tue, 29 Jan 2008 22:59:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; bh=7ZzvEhFpIDip5TqVwr3I1Pp6IujLLG9b29foSEL2wX8=; b=XdCe7VT2BUAhRhIcah+YZ0Crm4UmMNUTN7OwPROuBspNJ1d4Cy8MqyfXwdvWpfePOYea6M78wlGEirl+UxqagcNgSyLuMyi/JDzjv/B8G5qCf3sjgHer7gxVQLw1SMdUAlGSH1fBy+LZoXCvWyE58xSUzzRR69boCTo41INEhDU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=xM7bbjHahSMr0TudHYm5CebNTRDJxK35a5WpVTEXlr6zsaQEHnv2NuXBer+4hXkScV6Irqmox3vtlEly4cET5KrLLxAVFFzspoKs01jqj04oefCsW8wb+S6V0vV2eSd0ycm9TJaq9gKM7mjTkS3iH9g+9D8NHogH/Jrl36Ev+Do= Received: by 10.115.60.1 with SMTP id n1mr483555wak.37.1201676386761; Tue, 29 Jan 2008 22:59:46 -0800 (PST) Received: from ?10.1.1.19? ( [203.217.18.65]) by mx.google.com with ESMTPS id t1sm13374706poh.0.2008.01.29.22.59.44 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 29 Jan 2008 22:59:46 -0800 (PST) Message-ID: <47A01FAA.9060306@gmail.com> Date: Wed, 30 Jan 2008 17:56:42 +1100 From: Chris User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: Suresh Gupta VG CC: pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [GENERAL] Can we have 2 databases on same server References: <3D5445983859B84B92669C0D883EA6FB0C0A57B5@ZENMAILHQ1.ind.zensar.com> In-Reply-To: <3D5445983859B84B92669C0D883EA6FB0C0A57B5@ZENMAILHQ1.ind.zensar.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/282 X-Sequence-Number: 28056 > 1) Can I please know, if we can run 2 databases on the same server > with out any conflicts? You can as long as they are installed in separate locations. That is: db1: /usr/local/pgsql/7.4 db2: /usr/local/pgsql/8.1 The main reason is so your app doesn't pick up the wrong binary and use that and cause all sorts of weird and wonderful errors :) > 2) If it is so, at what stage we are need to configure the 2 > databases? Pls provide links or docs if available. http://www.postgresql.org/docs/8.2/static/install-procedure.html (look at the --prefix stuff). http://www.postgresql.org/docs/8.2/static/creating-cluster.html and http://www.postgresql.org/docs/8.2/static/install-upgrading.html for how to copy your data into the new system. They will also need to run on different ports. Edit the postgresql.conf file on the new install and change the port=5432 line to another (unused) number. -- Postgresql & php tutorials http://www.designmagick.com/ From Gregory.Williamson@digitalglobe.com Wed Jan 30 07:33:33 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 345DB2E018D; Wed, 30 Jan 2008 03:33:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 55246-06; Wed, 30 Jan 2008 03:33:25 -0400 (AST) Received: from copgpuniv.digitalglobe.com (ew-fw-out.digitalglobe.com [205.166.175.2]) by postgresql.org (Postfix) with ESMTP id DC4DC2E019B; Wed, 30 Jan 2008 03:33:27 -0400 (AST) Received: from copgpuniv.digitalglobe.com (localhost.localdomain [127.0.0.1]) by copgpuniv.digitalglobe.com (PGP Universal) with ESMTP id E584D2A02C7; Wed, 30 Jan 2008 00:33:25 -0700 (MST) Received: from comailgate2.digitalglobe.com ([10.10.42.200]) by copgpuniv.digitalglobe.com (PGP Universal service); Wed, 30 Jan 2008 00:33:25 -0700 X-PGP-Universal: processed; by copgpuniv.digitalglobe.com on Wed, 30 Jan 2008 00:33:25 -0700 Received: from COMAIL01.digitalglobe.com ([10.10.42.61]) by comailgate2.digitalglobe.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 30 Jan 2008 00:33:25 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C86312.65B7B93D" Subject: Re: Can we have 2 databases on same server Date: Wed, 30 Jan 2008 00:32:16 -0700 Message-ID: <8B319E5A30FF4A48BE7EEAAF609DB233015E32B2@COMAIL01.digitalglobe.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Can we have 2 databases on same server Thread-Index: Achi/3llDifcyTUSST2axBfhDjP0DQAChziQAAIpoEI= References: <3D5445983859B84B92669C0D883EA6FB0C0A57B5@ZENMAILHQ1.ind.zensar.com> From: "Gregory Williamson" To: "Suresh Gupta VG" , , X-OriginalArrivalTime: 30 Jan 2008 07:33:25.0567 (UTC) FILETIME=[663994F0:01C86312] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/283 X-Sequence-Number: 28057 This is a multi-part message in MIME format. ------_=_NextPart_001_01C86312.65B7B93D Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Suresh Gupta asked: >=20 > I have Solaris 9 machine with Pgsql 7.4 and want to upgrade to 8.2.5. = I > don't want to disturb the first version now. I want to install second > one separately and need to test with my application. If it works fine, = I > will activate only the latest one and other version 7.4 will be > discarded. This is my idea. >=20 > 1) Can I please know, if we can run 2 databases on the same = server > with out any conflicts? Absolutely. We have one server with 8.1.x, 8.2.x and 8.3RC2 one it. We = don't push more than one of them hard at any given time though, but we = probably could (disk contention would be the biggest issue). As others = pointed out, make different directories for the software and data. > 2) If it is so, at what stage we are need to configure the 2 > databases? Pls provide links or docs if available. Before firing up the new instance, make sure you have enough shared = memory allocated for *both* instances. Read the relevant docs pointed = out in another response and make sure you specify the correct = directories and ports etc. when running initdb to create the new 8.2 = database. Make sure you point the logs to different files as well. <...> HTH, Greg Williamson Senior DBA GlobeXplorer LLC, a DigitalGlobe company Confidentiality Notice: This e-mail message, including any attachments, = is for the sole use of the intended recipient(s) and may contain = confidential and privileged information and must be protected in = accordance with those provisions. Any unauthorized review, use, = disclosure or distribution is prohibited. If you are not the intended = recipient, please contact the sender by reply e-mail and destroy all = copies of the original message. (My corporate masters made me say this.) ------_=_NextPart_001_01C86312.65B7B93D Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: [ADMIN] Can we have 2 databases on same server

Suresh Gupta asked:

>
> I have Solaris 9 machine with Pgsql 7.4 and want to upgrade to = 8.2.5. I
> don't want to disturb the first version now. I want to install = second
> one separately and need to test with my application. If it works = fine, I
> will activate only the latest one and other version 7.4 will be
> discarded. This is my idea.
>
> 1)       Can I please know, if we can = run 2 databases on the same server
> with out any conflicts?

Absolutely. We have one server with 8.1.x, 8.2.x and 8.3RC2 one it. We = don't push more than one of them hard at any given time though, but we = probably could (disk contention would be the biggest issue). As others = pointed out, make different directories for the software and data.

> 2)       If it is so, at what stage = we are need to configure the 2
> databases? Pls provide links or docs if available.

Before firing up the new instance, make sure you have enough shared = memory allocated for *both* instances. Read the relevant docs pointed = out in another response and make sure you specify the correct = directories and ports etc. when running initdb to create the new 8.2 = database. Make sure you point the logs to different files as well.

<...>

HTH,


Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company

Confidentiality Notice: This e-mail message, including any attachments, = is for the sole use of the intended recipient(s) and may contain = confidential and privileged information and must be protected in = accordance with those provisions. Any unauthorized review, use, = disclosure or distribution is prohibited. If you are not the intended = recipient, please contact the sender by reply e-mail and destroy all = copies of the original message.

(My corporate masters made me say this.)


------_=_NextPart_001_01C86312.65B7B93D-- From chander@otg-nc.com Wed Jan 30 15:06:11 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 84A572E009D for ; Wed, 30 Jan 2008 11:06:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 89257-10 for ; Wed, 30 Jan 2008 11:06:01 -0400 (AST) Received: from smtp162.iad.emailsrvr.com (smtp162.iad.emailsrvr.com [207.97.245.162]) by postgresql.org (Postfix) with ESMTP id B7FE62E019F for ; Wed, 30 Jan 2008 11:06:01 -0400 (AST) Received: from relay6.relay.iad.emailsrvr.com (localhost [127.0.0.1]) by relay6.relay.iad.emailsrvr.com (SMTP Server) with ESMTP id 2C491702621; Wed, 30 Jan 2008 10:06:00 -0500 (EST) Received: by relay6.relay.iad.emailsrvr.com (Authenticated sender: chander-AT-otg-nc.com) with ESMTP id B6E27702798; Wed, 30 Jan 2008 10:05:59 -0500 (EST) Message-ID: <47A0925E.1070601@otg-nc.com> Date: Wed, 30 Jan 2008 10:06:06 -0500 From: Chander Ganesan User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: Suresh Gupta VG CC: pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [GENERAL] Can we have 2 databases on same server References: <3D5445983859B84B92669C0D883EA6FB0C0A57B5@ZENMAILHQ1.ind.zensar.com> In-Reply-To: <3D5445983859B84B92669C0D883EA6FB0C0A57B5@ZENMAILHQ1.ind.zensar.com> Content-Type: multipart/alternative; boundary="------------080001060302000002080901" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/287 X-Sequence-Number: 28061 This is a multi-part message in MIME format. --------------080001060302000002080901 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hello Suresh, Suresh Gupta VG wrote: > > Hi Team, > > > > I have Solaris 9 machine with Pgsql 7.4 and want to upgrade to 8.2.5. > I don't want to disturb the first version now. I want to install > second one separately and need to test with my application. If it > works fine, I will activate only the latest one and other version 7.4 > will be discarded. This is my idea. > > > > 1) Can I please know, if we can run 2 databases on the same > server with out any conflicts? > It looks like you already got the answer on this one.. however, your terminology is a bit off. Unlike Oracle (where we think in terms of "databases"), in PostgreSQL we think in terms of "clusters", where a cluster (often used interchangeably with the word "server") is a collection of databases. A cluster listens on a single port, has a single "data" directory, and manages a single list of roles (accounts and groups) that span all of the databases that are managed by the cluster. Hope that helps. When you read the documentation you will see references to "Clusters", not databases... -- Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC 27560 919-463-0999/877-258-8987 http://www.otg-nc.com Ask me about Expert PostgreSQL & PostGIS Training Delivered Worldwide. --------------080001060302000002080901 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hello Suresh,

Suresh Gupta VG wrote:

Hi Team,

 

I have Solaris 9 machine with Pgsql 7.4 and want to upgrade to 8.2.5. I don’t want to disturb the first version now. I want to install second one separately and need to test with my application. If it works fine, I will activate only the latest one and other version 7.4 will be discarded. This is my idea.

 

1)       Can I please know, if we can run 2 databases on the same server with out any conflicts?

It looks like you already got the answer on this one.. however, your terminology is a bit off.  Unlike Oracle (where we think in terms of "databases"), in PostgreSQL we think in terms of "clusters", where a cluster (often used interchangeably with the word "server") is a collection of databases.  A cluster listens on a single port, has a single "data" directory, and manages a single list of roles (accounts and groups) that span all of the databases that are managed by the cluster.

Hope that helps.  When you read the documentation you will see references to "Clusters", not databases...
-- 
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC  27560
919-463-0999/877-258-8987
http://www.otg-nc.com
Ask me about Expert PostgreSQL & PostGIS Training Delivered Worldwide.
--------------080001060302000002080901--