[opencms-dev] How to move DB from one computer to another?

[Ronen Naor]

Yes, it was my mistake. I didn't do the backup and restore of the
database correctly. It was pure issue of misusing of postgres.
Thanks,
Ronen.

-----Original Message-----
From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Jack Bakker
Sent: Tuesday, December 16, 2008 5:37 PM
To: 'The OpenCms mailing list'
Subject: Re: [opencms-dev] How to move DB from one computer to another?

what do you  mean by OpenCms database version 7.0.5 ? there is OpenCms
v7.0.5 and then there is postgresql v8.2.x ; v8.3.x ; etc.

OpenCms v7.0.5 has a pg driver for v8.3 

if you are not upgrading anything (unlikely), then it likely is ... your
fault ?

but if there is an underlying change give more info as to intervening
variables

(I'm busy right now moving my dev enviornment to an 64 bit ubuntustudio
8.10, to pg 8.3, all projects to opencms 7.0.5, to java 6, etc. etc.
while
trying to make sure my 'more legacy' staging and production environments
don't fail)

................
Jack  

> -----Original Message-----
> From: opencms-dev-bounces at opencms.org 
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of 
> Pomegranate Software- Arash Kaffamanesh
> Sent: Tuesday, December 16, 2008 10:28 AM
> To: The OpenCms mailing list
> Subject: Re: [opencms-dev] How to move DB from one computer 
> to another?
> 
> Hi,
> I guess similar to MySQL, you have to grant permissions / 
> privileges to the user (postgres or root, etc.) from his host 
> (in your case the same app server) to connect to the database 
> on the new POSTGRESQL server.
> 
> See also: 
> http://www.pomegranate.de:9000/cms/forum/viewthread?thread=18
> 
> HTH,
> Best,
> Arash
> 
> --
> Run OpenCms in 5 Minutes!
> <http://www.pomegranate.de:9000/cms/forum/viewthread?thread=144>
> 
> 
> Ronen Naor wrote:
> >
> > Hi,
> >
> > I need to move my OpenCms database version 7.0.5 from one 
> computer to 
> > another. I'm using POSTGRESQL version 8.
> >
> > When I tried just to do backup and restore database it didn't work.
> >
> > Do I need to do some extra modifications as well?
> >
> > Thanks,
> >
> > Ronen.
> >
> >
> >
> > The information contained in this message is proprietary to the 
> > sender, protected from disclosure, and may be privileged. The 
> > information is intended to be conveyed only to the designated
> > recipient(s) of the message. If the reader of this message 
> is not the 
> > intended recipient, you are hereby notified that any dissemination, 
> > use, distribution or copying of this communication is strictly 
> > prohibited and may be unlawful. If you have received this 
> > communication in error, please notify us immediately by replying to 
> > the message and deleting it from your computer. Thank you.
> >
> >
> >
> >
> >
> > 
> **********************************************************************
> > ************** This footnote confirms that this email 
> message has been 
> > scanned by PineApp Mail-SeCure for the presence of malicious code, 
> > vandals & computer viruses.
> > 
> **********************************************************************
> > **************
> >
> >
> > 
> ----------------------------------------------------------------------
> > --
> >
> >
> > _______________________________________________
> > This mail is sent to you from the opencms-dev mailing list 
> To change 
> > your list options, or to unsubscribe from the list, please visit 
> > http://lists.opencms.org/mailman/listinfo/opencms-dev
> 
> 
> 
> 
> 
> 
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list To 
> change your list options, or to unsubscribe from the list, 
> please visit http://lists.opencms.org/mailman/listinfo/opencms-dev
> 


_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please
visit
http://lists.opencms.org/mailman/listinfo/opencms-dev



(null)





 
 
************************************************************************
************
This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals &
computer viruses.
************************************************************************
************






The information contained in this message is proprietary to the sender, protected from disclosure, and may be privileged. The information is intended to be conveyed only to the designated recipient(s) of the message. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, use, distribution or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you.





 
 
************************************************************************************
This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals & computer viruses.
************************************************************************************