[Ilugc] Moving postgreSQL /data folder between systems

[Arun Khan]

[1] AMD64 system  (dead/RIP)
OS: openSUSE 11.1 (x86_64)
PG: 8.3

[2] Intel Pentium IV (working system)
OS: openSUSE 11.1 (x86)
PG: 8.3

I had a couple of applications using PostgreSQL backend on an AMD64 
based system.  Unfortunately, the motherboard decided to RIP; so it is 
not  possible of getting a db dump.   The hard disk is fine though.  

I migrated the hard disk from [1] to [2], copied /var/lib/pgsql/data 
from [1] to /var/lib/pgsql/data on [2].  I ensured that postgresql was 
stopped during the process.  After copying the data files, postgresql 
fails to start.  I have checked that file ownership and permissions are 
the same between a running postgresql and the above setup.

The following links (from Google search) suggest that above procedure 
should work.




Any suggestions/pointers as what may be wrong with what I am trying to 
do.

TIA,
-- Arun Khan

___
To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with 
"unsubscribe  "
in the subject or body of the message.  
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc

Re: [Ilugc] Moving postgreSQL /data folder between systems

[Raja Subramanian]

On Fri, May 1, 2009 at 11:09 PM, Arun Khan  wrote:
> ... After copying the data files, postgresql
> fails to start.

What do the db error logs say?

- Raja
___
To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with 
"unsubscribe  "
in the subject or body of the message.  
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc

[Ilugc] Re: Recovery with testdisk

[K.C. Ramakrishna]

Updates:

While trying to recover, I had another idea, if you remember, I theorised that 
"Simple backup and restore" created a directory in /media.
Following up on that theory, I used testdisk to go to /media/KC in the old 
partition of my laptop harddisk and lo behold, the directory did exist and all 
my backups (almost 15 of them - I am a paranoid backer upper) were safely in 
that directory. 
!!! WIN !!!
I recovered all my incremental backup files. I had my original full backup and 
hence have all my data back.

BTW, Ubuntu puts the underscore *after* the name. Since /media/KC" was created 
by "Simple backup", Ubuntu created the directory "/media/KC_"
and not "/media/_KC" (i.e. the underscore is *after* "KC" and not before) as I 
wrongly reported in my earlier email.


Moral of the story:
1. Take regular backups on external media like DVDs and keep testing restores 
once a month or so.
2. Keep thanking the selfless souls who write great software and release it 
under GPL
3. Make contributions to projects which save your life - either code, bug 
reports, testing, documentation or cash (I am donating $$ to testdisk!!)

With this exercise, I have become pretty experienced in data recovery -
I recovered a mysql DB after a bug dropped all tables in the DB in the
production server. It was a new server and we still hadn't started
automated backups on it. It is possible to recover the DB from just the
ibdata files provided you have the schema and have some idea of the
text content of the tables. 

I would also recommend Jaunty - Ubuntu 9.04 to all. It really is very good. 
Though I have been a lifelong RH/Fedora fan and use Fedora/CentOs on servers as 
well as my laptop, I started dual booting (actually quadraple booting - Fedora, 
Ubuntu, Suse and ...) Ubuntu since 7.10. With 9.04 I think I have migrated 
completely to Ubuntu on my laptop. I erased Fedora 10. I am very used to 
Fedora/Cent on servers mainly because I have been using it since 1999 and know 
it well - .profiles, .rc, service controls, init.d.but for everyday office 
use - documents, scans, productivity...Ubuntu is really up there. In terms of 
usability for non-geeks, I think Ubuntu has finally beaten Windows. The 
usability is fantastic and desktop effects work without binary drivers. It is 
very close to Mac and should beat it too pretty soon.

Thanks to all for reading my lng emails and for pitching in with 
suggestions. 

kc
K. C. Ramakrishna
www.rknowsys.com


  
___
To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with 
"unsubscribe  "
in the subject or body of the message.  
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc

Re: [Ilugc] Moving postgreSQL /data folder between systems

[Arun Khan]

On Saturday 02 May 2009, Raja Subramanian wrote:
> On Fri, May 1, 2009 at 11:09 PM, Arun Khan  wrote:
> > ... After copying the data files, postgresql
> > fails to start.
>
> What do the db error logs say?
>

Are you referring to the ones in the /var/lib/pgsql/data directory?  
Nothing there.

When I do /etc/init.d/postgresql start the only indication I get 
is "failed" message on the terminal.

-- 
Arun Khan

___
To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with 
"unsubscribe  "
in the subject or body of the message.  
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc

Re: [Ilugc] Moving postgreSQL /data folder between systems

[Raja Subramanian]

On Sat, May 2, 2009 at 9:48 AM, Arun Khan  wrote:
> Are you referring to the ones in the /var/lib/pgsql/data directory?
> Nothing there.

No, not the DB transaction logs.

I'm referring to /var/log/postgresql.log or syslog or wherever
your log_destination is set to in postgresql.conf.

- Raja
___
To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with 
"unsubscribe  "
in the subject or body of the message.  
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc

[Ilugc] subversion page load is very slow

[mettur salem]

Dear Senthil

Thanks for your mail
I am using in plain http:// not viewvc  ( dont know viewvc client people
using tortoise svn )

I want to restiriction for only some people is allow to commit in the server
any idea suggestion
please share  senthil

with Regards,
Mettur Mohan

Message: 2
Date: Thu, 30 Apr 2009 15:18:19 +0530
From: Senthil Kumaran S 
Subject: Re: [Ilugc] subversion access Page load is very slow
To: ILUG-C 
Message-ID:
   <5ef2113c0904300248l1c467773gce7e79f2a8678...@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

On Wed, Apr 29, 2009 at 12:13 PM, mettur salem
 wrote:
>  i have restarted the network service httpd service  , and finally restart
> the server still very low
> in page load

Are you accessing subversion over plain http:// or using viewvc?

--
Senthil Kumaran S
http://www.stylesen.org/
___
To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with 
"unsubscribe  "
in the subject or body of the message.  
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc

Re: [Ilugc] Avahi: Publishing a service on a different hostname

[Roshan George]

On Fri, 2009-05-01 at 09:57 +0530, Arun Khan wrote:
> The db.lan zone file looks OK, although I prefer to use a A record for 
> the "ns" "mx" hosts rather than CNAME.  I have not seen a CNAME record 
> with a wild card hostname such as "*.pan CNAME pan" but if it works 
> great.
Right, I will make those changes anyway.

> I would suggest you search through the avahi mailing lists and/or hang 
> out there, I am sure the authors and guru level users hang out there 
> and get more competent help there.

Thanks, I'll see what I can get there.
-- 
Regards,
Roshan George 

___
To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with 
"unsubscribe  "
in the subject or body of the message.  
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc