Re: [ADMIN] restore database files

2010-12-24 Thread Jasen Betts
On 2010-12-14, gosta100 wrote: > > Hello everyone, > >I have a copy of the data folder of a Windows postgres installation. Is > it possible to restore the databases contained in there to another postgres > server? yes, you'll need to correct the permissions on the files and run copy them onto

Re: [ADMIN] "root" execution not permitted. and busybox

2010-12-27 Thread Jasen Betts
On 2010-12-23, Nicolas BALDECK wrote: > Hi guys, > this is driving me crazy... Do someone have an idea ? run some diagnotsics. (id -a, ls -l) maybe install a more complete environment temporarily. > $ /tmp/mnt/usb0/part1/usr/bin/postmaster -D '/tmp/mnt/usb0/part1/caisse/db' > "root" executio

Re: [ADMIN] Unable to install 9.0 postgre in debian-lenny

2010-12-27 Thread Jasen Betts
On 2010-12-27, ℓєѕℓιє ѕαмυєℓ wrote: > --0016363ba666df16580498676542 > Content-Type: text/plain; charset=ISO-8859-1 > > Dear friends, > > I have installed the debian-lenny in my system.. Lenny is having 8.3 > postgres as a default package. > I have installed 8.4 postgres successfully. But I unab

Re: [ADMIN] Finding missing values in sequence column

2010-12-30 Thread Jasen Betts
On 2010-12-30, Lukasz Brodziak wrote: > Hello, > > I have a problem with writing a select statement that would return > records for which difference in values of this and following ID is > bigger than 1. Example table > ID Data > 1 Text > 2 Text2 > 5 Text5 > 23 Text23 >

Re: [ADMIN] Migrating a live database

2011-01-18 Thread Jasen Betts
On 2011-01-18, Vladislav Geller wrote: > Hello, > > I'm currently in the process of migrating a huge live database from > one part of the world to the other (for local use and data analysis). > The bandwidth does not allow me to get a decent transfer speed. > Furthermore i can not migrate during b