Restoring a raw PostgreSQL backup from an ancient server? -

-

all guides can find suggest migrating psql database easy. call pg_dump out @ 1 end , can suck @ other. simple if remembered pg_dump!

two years or ago, migrated server crusty old 32bit server newer, fresher 64bit install. backed essentials (/etc, /var, /home, etc...) being quite new @ time, ignored postgresql , didn't restore on new server.

sound odd? client uses moodle site use once in moon , has never needed in time. it's full moon today. client savage database isn't available.

i have /var/lib/postgresql/9.1/... files initial backup still. try supplant new /var/lib/postgresql/9.3/... files different arch, , i've read several things suggesting won't work. don't want things worse.

is there way restore old database or somehow convert neutral plaintext sql can reimported?

you correct 64-bit postgresql can't read 32-bit postgresql data directory. nor 9.3 read 9.1 data directory.

you need 32-bit postgresql 9.1 access this.

because x86_64 cpu can run 32-bit binaries without emulation, have couple of options:

  • install 32-bit postgresql 9.1 using debian/ubuntu packages directly on current system, pulling in required 32-bit libraries. i'd try first, might easiest. check http://apt.postgresql.org/ see if there 32-bit 9.1 binaries os.

  • failing that, launch virtual machine running original operating system data directory created on using libvirt+kvm, vagrant+virtualbox, or whatever, install postgresql 9.1 original os packages on it.

  • as final alternative install 32-bit gcc , relevant postgresql dependencies (apt-get build-essential:i386, apt-get build-dep postgresql:i386 think, don't have debian/ubuntu machine hand test with) compile postgresql 9.1 i386 using toolchain.

whichever way it, want use 9.1 binaries to path=/path/to/9.1/bin pg_ctl -d /path/to/copy/of/database -w start postgresql, pg_dump - if possible, using new pg_dump 9.3. strongly recommend using pg_dumpall --globals-only, pg_dump -fc each individual database wish dump.

now go check backups , make sure in future you're doing periodic dumps.


Comments

Post a Comment

Popular posts from this blog

google chrome - Developer tools - How to inspect the elements which are added momentarily (by JQuery)? -

-
i looking @ how website designed using inspector in chrome. can use firefox developer tools or firefox web developer add-on or chrome web developer extension. so website has slide-show , using jquery it. looking @ markup , css in inspector, i see 2 things constantly changing slides change: one opacity css property understandable, i'd see changing values, changes fast see read anything. second- a div added in div slides change momentarily , moment when appears short notice except div . so question is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? where can inspect div element gets added such short moment , , gets removed? , can see changes in value of opacity takes place? is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? if opacity animated css transition or animation,
Read more

angularjs - Showing an empty as first option in select tag -

-
my app showing empty select field first entry. have read other solution given , tried still not working. my controller code is: .controller('usercreatecontroller', function(user,profile,auth) { alert("hello"); var vm = this; vm.type = 'create'; profile.all() //this service fetch profiles shown in select field .success(function(data){ vm.profile = data; }); vm.userdata.profile = vm.profile[0]; //here have set default value select field and html page is: <label class="col-sm-2 control-label">profile</label> <div class="col-sm-8"> <select ng-model="user.userdata.profile" ng-options="person._id person.profilename person in user.profile"> </select> </div> hierarchy of vm.profile { "_id": 46, "profile": objectid("5516498e95b84548156db754"), "isactive": true, "password": "$2
Read more

php - Cloud9 cloud IDE and CakePHP -

-
i attempting cakephp running on cloud9, cloud based ide. unaware, cloud collaboration ide intermixes services such bitbucket. site gives sudo rights, , installed cakephp using these instructions: https://www.digitalocean.com/community/tutorials/how-to-install-cakephp-on-an-ubuntu-12-04-vps when attempt run database exported machine cakephp installed, error message "url rewriting not configured on server." attempted solve issue using official guide cakephp: http://book.cakephp.org/2.0/en/installation/url-rewriting.html but no cigar, same error message. has gotten cakephp working, or aware of cloud ide free/low cost cloud9 support cakephp? here's how got working now: sudo apt-get update sudo apt-get install php5-intl curl -ss https://getcomposer.org/installer | php -- --filename=composer ./composer create-project --prefer-dist cakephp/app this creates project in /app default. move workspace docroot: mv app/* ./ mv app/.* ./ rm -rf app then de
Read more