[GENERAL] PgSQL dump

blob field? I tried to look at keys of pgdump, but found nothing... Now we are using it like this: pg_dump -f /home/backup/DB.sql -d -Fp -v DB thx Lukas -- This message has been scanned for viruses and dangerous content, and is believed to be clean. ---(end of broadcast

[GENERAL] PGConf NYC 2015 videos

Hi Where can I download PGConf NYC 2015 videos? Was there a recording? I live in Europe. Please point me to torrent link. There are lots of interesting talks. Lukas

Re: [GENERAL] PGConf NYC 2015 videos

On Wed, May 13, 2015 at 3:50 PM, Jim Mlodgenski wrote: > We were not planning on posting to -general because to me it seems off > topic, but if no one objects we can. We were planning on announcing it > through the normal social media channels for the conference like > the @PGConfUS Twitter handl

[GENERAL] please remove outdated site from 2005

Hi when I use a search engine for the term "Postgres Certification" this page shows up https://www.postgresql.org/about/news/333/ please remove that, very much outdated. The referenced link doesn't exist anymore (404 No such domain) Lukas

[GENERAL] Resize numeric column without changing data?

bout how numeric is stored on disk that I need be concerned about when altering the column in this method? Is it safe to just alter the metadata? Thanks, -- Lukas Eklund lu...@eklund.io -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Resize numeric column without changing data?

On Mon, Apr 9, 2012 at 2:51 PM, Merlin Moncure wrote: > On Mon, Apr 9, 2012 at 9:57 AM, Lukas Eklund wrote: >> Is it safe to resize a numeric column using in pg_attribute without >> altering the table? >> > > One thing that's pretty weird is that dependent vi

Re: [GENERAL] Resize numeric column without changing data?

On Mon, Apr 9, 2012 at 6:16 PM, Jeff Davis wrote: > On Mon, 2012-04-09 at 16:06 -0400, Lukas Eklund wrote: >> Ah. I must have not noticed that the typmod for views is not inherited >> automatically. I'm okay with developing a script to recreate the 15 or >> so views the

[GENERAL] PGSQL x iptables

5432 -j ACCEPT". I'm really confused - what other states are possible for iptables except ESTABLISHED, RELATED or NEW? In iptables manpage is only INVALID, but why is this state emerging? Any idea? Lukas

Re: [GENERAL] PGSQL x iptables

> Slansky Lukas wrote: > > > 1. -A RH-Firewall-1-INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT > > > > 2. -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp -s > > aaa.bbb.ccc.ddd --dport 5432 -j ACCEPT > > > > 3. -A RH-Firewall-1-INPUT -j

Re: [GENERAL] PGSQL x iptables

after turning SACKs off seems connection stabile. But we'll try to figure out why are such packets produced. But it will probably take time... Thanks, Lukas -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Craig R

[GENERAL] Embed PostgreSQL in application

o minimize or remove completely the need for a user to install PostgreSQL on his own. Thanks for the responses -- Lukas Demetz Digiem Snc http://www.digiem.net