[SQL] apt.postgresql.org vs. Pitti PPA - install error
Working on Ubuntu 13.04 64bit (raring) I red, that Pitti-PPA will be discontinued in the future, so we should make the switch to apt.postgresql.org. But trying to "aptitude install postgresql-9.3" (and with 9.2 - the same) I get an install error: The following packages have unmet dependencies: postgresql-common : Breaks: logrotate (>= 3.8) but 3.8.3-3ubuntu2 is installed. Going back to the Pitti PPA I could install pg-9.2 without problems (there will be no 9.3 in there) Regards Rawi -- View this message in context: http://postgresql.1045698.n5.nabble.com/apt-postgresql-org-vs-Pitti-PPA-install-error-tp5759622.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] apt.postgresql.org vs. Pitti PPA - install error
Please post your /etc/apt/source.list entry and "lsb_release -c" Am 18.06.2013 12:12, schrieb rawi: > Working on Ubuntu 13.04 64bit (raring) > > I red, that Pitti-PPA will be discontinued in the future, so we should make > the switch to apt.postgresql.org. > > But trying to "aptitude install postgresql-9.3" (and with 9.2 - the same) I > get an install error: > > > The following packages have unmet dependencies: > postgresql-common : Breaks: logrotate (>= 3.8) but 3.8.3-3ubuntu2 is > installed. > > > Going back to the Pitti PPA I could install pg-9.2 without problems (there > will be no 9.3 in there) > > Regards > Rawi > > > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/apt-postgresql-org-vs-Pitti-PPA-install-error-tp5759622.html > Sent from the PostgreSQL - sql mailing list archive at Nabble.com. > > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] apt.postgresql.org vs. Pitti PPA - install error
/etc/apt/sources.list.d/apt_postgresql_org.list: deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main 9.3 (for 9.2 also tryed only 'deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main') lsb_release -c Codename: raring but there is no repository for raring... so I took then the precise one... Thank you! Regards, Rawi -- View this message in context: http://postgresql.1045698.n5.nabble.com/apt-postgresql-org-vs-Pitti-PPA-install-error-tp5759622p5759636.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
[SQL] Re: Index Usage and Running Times by FullTextSearch with prefix matching
rawi wrote > > Tom Lane-2 wrote >> FWIW, I get fairly decent performance for cases like this in HEAD >> (at least with a GIN index; GIST seems much less able to do well with >> short prefixes). What PG version are you testing? > Thank you Tom, > > I'm testing on PG 9.1 on UbuntuServer 12.10, 64bit > > I'll update to 9.2 the next days and try again. > > Kind Regards > Rawi Just tested with 9.2: pretty much the same -- View this message in context: http://postgresql.1045698.n5.nabble.com/Index-Usage-and-Running-Times-by-FullTextSearch-with-prefix-matching-tp5759021p5759645.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
