Re: [Dspace-tech] Backup Error
On Fri, Jan 30, 2009 at 12:55:17PM +0530, Geetha Rao wrote: Thanks for your quick reply. I have few more doubts regarding postgresql. Actually i have installed Postgresql 8.1.3. But recently i have noticed that Postgresql 7.3 is already present in my system. I think RedHat 9 defaulty gives postgresql 7.3. I have uploaded some articles Through UI in Dspace. Now, am unable to understand that which version of postgresql is Dspace using? Its whether postgresql 7.3 or Postgresql 8.1? When i used the commands *which psql* , *which pg_dump*. I got the following output: */usr/bin/psql* */usr/bin/pg_dump* That only shows you the path that will be used if you don't specify a path. 'which -a psql' should show you *all* of the paths on which 'psql' is found. One of those paths should lead to version 8.1.3. If you don't need that ancient Pg 7.3.2 it might be best to remove it. -- Mark H. Wood, Lead System Programmer mw...@iupui.edu Friends don't let friends publish revisable-form documents. pgpnhhcOEjYYI.pgp Description: PGP signature -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Backup Error
Hi, I have installed Dspace 1.5 on RedHat 9 with Postgresql 8.1. When i tried to use the command pg_dump , the following error is displayed: *pg_dump: server version: ; pg_dump version: 7.3.2* *pg_dump: aborting because of version mismatch (Use the -i option to proceed any way)* ** ** Please, give me the steps to take backup of my DataBase. Regards, Geetha -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Backup Error
On Thu, Jan 29, 2009 at 03:31:24PM +0530, Geetha Rao wrote: I have installed Dspace 1.5 on RedHat 9 with Postgresql 8.1. When i tried to use the command pg_dump , the following error is displayed: *pg_dump: server version: ; pg_dump version: 7.3.2* *pg_dump: aborting because of version mismatch (Use the -i option to proceed any way)* Notice that pg_dump reports its version as 7.3.2, yet you say you're running PostgreSQL version 8.1. Apparently there is an older version of the Pg tools somewhere on your PATH.You need to remove the older versions of the Pg tools, or rearrange PATH so that the new ones come first, or specify an explicit path to the version of pg_dump that you need to use. You must use a pg_dump that is at least as high a version as the Pg postmaster process. I think that 'which -a pg_dump' will show you all of the versions of pg_dump which are visible on your PATH. This may help you track down the version you need. If you have a good reason to maintain two versions of Pg on your host, you should be aware that cron jobs may be run with a very different PATH from the one you get in an interactive session. Just because the commands run interactively does not guarantee that you will get the same versions in an automated backup job. -- Mark H. Wood, Lead System Programmer mw...@iupui.edu Friends don't let friends publish revisable-form documents. pgpLVzQRZHkMn.pgp Description: PGP signature -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Backup Error
Hi, Check if you've more than one pg_dump on your system by updatedb ; locate pg_dump And, if there are multiples, to get an indication of version numbers, for each rpm -qf /absolute/path/to/pg_dump -- Van Ly : University of Sydney Library -Original Message- From: Geetha Rao [mailto:iictdsp...@gmail.com] Sent: Thu 29/01/2009 9:01 PM To: DSpace-tech@lists.sourceforge.net Subject: [Dspace-tech] Backup Error Hi, I have installed Dspace 1.5 on RedHat 9 with Postgresql 8.1. When i tried to use the command pg_dump , the following error is displayed: *pg_dump: server version: ; pg_dump version: 7.3.2* *pg_dump: aborting because of version mismatch (Use the -i option to proceed any way)* ** ** Please, give me the steps to take backup of my DataBase. Regards, Geetha -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Backup Error
Hi, Thanks for your quick reply. I have few more doubts regarding postgresql. Actually i have installed Postgresql 8.1.3. But recently i have noticed that Postgresql 7.3 is already present in my system. I think RedHat 9 defaulty gives postgresql 7.3. I have uploaded some articles Through UI in Dspace. Now, am unable to understand that which version of postgresql is Dspace using? Its whether postgresql 7.3 or Postgresql 8.1? When i used the commands *which psql* , *which pg_dump*. I got the following output: */usr/bin/psql* */usr/bin/pg_dump* I have also used the commands *pg_dump --version* *psql --version*. I got the following output: *pg_dump (PostgreSQL) 7.3.2* *psql (PostgreSQL) 7.3.2* Please help me. Regards, Geetha On Thu, Jan 29, 2009 at 7:16 PM, Van Ly v...@library.usyd.edu.au wrote: Hi, Check if you've more than one pg_dump on your system by updatedb ; locate pg_dump And, if there are multiples, to get an indication of version numbers, for each rpm -qf /absolute/path/to/pg_dump -- Van Ly : University of Sydney Library -Original Message- From: Geetha Rao [mailto:iictdsp...@gmail.com iictdsp...@gmail.com] Sent: Thu 29/01/2009 9:01 PM To: DSpace-tech@lists.sourceforge.net Subject: [Dspace-tech] Backup Error Hi, I have installed Dspace 1.5 on RedHat 9 with Postgresql 8.1. When i tried to use the command pg_dump , the following error is displayed: *pg_dump: server version: ; pg_dump version: 7.3.2* *pg_dump: aborting because of version mismatch (Use the -i option to proceed any way)* ** ** Please, give me the steps to take backup of my DataBase. Regards, Geetha -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech