Re: [GENERAL] Backup database remotely

2012-02-18 Thread Jasen Betts
On 2012-02-15, Andre Lopes wrote: > Hi all, > > To do this backup remotely we need to open the 5434 port in the Firewall? Yes, you need a connection to the database, opening the firewall is the simplest way to get that. (other ways include VPN and ssh tunneling) >> pg_dump -h (or pg_dumpall)

Re: [GENERAL] MySQL search query is not executing in Postgres DB

2012-02-18 Thread Daniel Neugebauer
On 02/19/2012 12:05 AM, Susanne Ebrecht wrote: > Am 17.02.2012 17:24, schrieb Alban Hertroys: >> On 17 February 2012 17:19, Scott Marlowe >>> Have you tried casting to varchar(1000) or something like that? >> Don't MySQL's varchars only go to 255? That's why every MySQL database >> uses blobs for t

Re: [GENERAL] MySQL search query is not executing in Postgres DB

2012-02-18 Thread Susanne Ebrecht
Am 17.02.2012 17:24, schrieb Alban Hertroys: On 17 February 2012 17:19, Scott Marlowe Have you tried casting to varchar(1000) or something like that? Don't MySQL's varchars only go to 255? That's why every MySQL database uses blobs for text data, isn't it? Yes. -- Dipl. Inf. Susanne Ebrecht

Re: [GENERAL] autovacuum and deadlocks

2012-02-18 Thread Scott Marlowe
On Sat, Feb 18, 2012 at 8:59 AM, Gregg Jaskiewicz wrote: > What is a likelihood of a deadlock occurring, caused (or helped by) > auto vacuum. > This is on 8.3. > > The table with deadlocks was quite busy with updates, etc. The only locking issues (not deadlocks) I've ever had with autovacuum were

[GENERAL] autovacuum and deadlocks

2012-02-18 Thread Gregg Jaskiewicz
What is a likelihood of a deadlock occurring, caused (or helped by) auto vacuum. This is on 8.3. The table with deadlocks was quite busy with updates, etc. -- GJ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.or

Re: [GENERAL] Pokey Fedora Updates for Postgresql?

2012-02-18 Thread Jerry Levan
On Feb 17, 2012, at 4:58 PM, Tom Lane wrote: > Jerry Levan writes: >> On Feb 17, 2012, at 4:21 PM, Tom Lane wrote: >>> I beg your pardon? > >> Sorry, they do not appear in *my* 'yum update' or yumex or the software >> update program. > > Huh. Something broken on your end, but what? The only

[GENERAL] Full text search ranking: ordering using index and proximiti ranking with OR queries

2012-02-18 Thread Andrey Chursin
Hello I have two unrelated questions about fts function ts_rank: 1) I've created GiST index on column with fts vector, but query SELECT * FROM table ORDER BY ts_rank(field, :query) LIMIT 20 is perfomed with sequential table scan. Index was created on field column. Does it mean FTS indexes does no

[GENERAL] Question on Rules

2012-02-18 Thread mgould
I am creating a rule which will copy a record when it is changed to a audittable. My question is that the first column is a UUID data type with a defined as auditaccessorid uuid DEFAULT isscontrib.uuid_generate_v4() NOT NULL, Right now I've got that set to NULL to allow the parser to "compile".

Re: [GENERAL] MySQL search query is not executing in Postgres DB

2012-02-18 Thread premanand
Hi Marti, Thanks for your reply. It works as expected. Regards, Prem -- View this message in context: http://postgresql.1045698.n5.nabble.com/MySQL-search-query-is-not-executing-in-Postgres-DB-tp5492402p5494971.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Se