Re: [ADMIN] Migrating a live database
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 business hours since the > connection is critical. This leaves me with a timeframe of 9 hours a > day where i can migrate this database. Does anyone have experience he > is willing to share in respect how to migrate such databases? how about using replication? eg: slony1 or wal-shipping compression will help too, but I assume you're already doing that. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] Finding missing values in sequence column
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 > 24 TXT > 25 > > So I need to return rows with IDs 2,5,23. SELECT id FROM Example EXCEPT SELECT id-1 FROM Example; select * FROM Example WHERE id+1 NOT IN ( SELECT id FROM Example ); > -- > Łukasz Brodziak > "What if everyting around You isn't quite as it seems, > What if all the world You think You know is an inelaborate dream > When You look at Your reflection is that all you want it to be > What if You could look right through the cracks > Would You find Yourself.. Find Yourself afraid to see" > -- ⚂⚃ 100% natural -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] Unable to install 9.0 postgre in debian-lenny
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 unable to install 9.x > postgres in that same machine. > Whether postgres 9.x won't support lenny or what ? Let me now plzz. > > Thanks in advance.. The default postgres configuration supports only one instance (called a cluster) installed on each server (you can have more by changing configuration settings). Debian does some stuff in the postgresql-common package to allow several to be easily installed on one server. If you installed 8.4 from postgres.org (not from debian-backports) it will have occupied the postgres default location and thus be blocking the install of 9.x -- ⚂⚃ 100% natural -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] "root" execution not permitted. and busybox
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" execution of the PostgreSQL server is not permitted. what's the UID at this moment? what's the file sytem type of /tmp/mnt/usb0/part1/ -- ⚂⚃ 100% natural -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] restore database files
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 an equivalent version of postgres for windows. -- ⚂⚃ 100% natural -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin