Re: [ADMIN] encoding shp2pgsql/ client encoding

On Fri, Nov 27, 2009 at 3:45 AM, Brian Modra wrote: > 2009/11/26 Melanie Hofmann : > > Hello, > > > > I'm a very big problem. I want to load shapefiles in a postgresql with > > shp2pgsql and psql. So i create the statement on a windows DOS console. I > > get below error FEHLER: ungültige Byte-Se

Re: [ADMIN] Replication solution

We are currently using Slony for our client's database that has million of rows on some tables and 12GB of raw data. So far so good, we set it up as a service and using a watchdog script to monitor and notify us in case the service fails. On Fri, Nov 27, 2009 at 12:19 AM, Dimitri Fontaine wrote:

[ADMIN] Windows 7

Hi there I have read the PG8.4 supports Windows 7 but it is not listed in your FAQ's (I'm just not sure when they were last updated). Can you please tell me if the two are compatible? Thanks, Marty Marty Dinniss Ph (04) 384 5618 Mob (021)775

[ADMIN] Help me understanding the schema

hi, i've used postgresql for few months now, but i still don't understand about the schema/database part and it's security consideration.. was there any better documentation (with pictures ^^) than this: http://www.postgresql.org/docs/current/static/ddl-schemas.html so, here's my current statement

Re: [ADMIN] Replication solution

As much of a pain as slony can be to setup and get working on a large data set, it is pretty solid and reliable for us too. Our DB is about 100G or so. On Sun, Nov 29, 2009 at 9:09 PM, Mark Guadalupe wrote: > We are currently using Slony for our client's database that has million of > rows on so

Re: [ADMIN] Help me understanding the schema

On Mon, Nov 30, 2009 at 5:19 PM, Kiswono Prayogo wrote: > hi, i've used postgresql for few months now, but i still don't understand > about the schema/database part and it's security consideration.. > was there any better documentation (with pictures ^^) than > this: http://www.postgresql.org/docs

Re: [ADMIN] Help me understanding the schema

Hi Scott, >> 7. we can set the privilege of user x for schema y >> ie. database aaa contains schema a1, a2 and a3. user xx can query from >> schema a1 only, user yy can query from schema a2 only? > No, perms on schemas control schema actions like create. perms on > tables control user access.

Re: [ADMIN] Help me understanding the schema

Le samedi 5 décembre 2009 à 23:08:58, Andy Shellam (Mailing Lists) a écrit : > Hi Scott, > > >> 7. we can set the privilege of user x for schema y > >> ie. database aaa contains schema a1, a2 and a3. user xx can query from > >> schema a1 only, user yy can query from schema a2 only? > > > > No, p

Re: [ADMIN] Help me understanding the schema

On Sat, Dec 5, 2009 at 3:46 PM, Guillaume Lelarge wrote: > Le samedi 5 décembre 2009 à 23:08:58, Andy Shellam (Mailing Lists) a écrit : >> Hi Scott, >> >> >> 7. we can set the privilege of user x for schema y >> >>   ie. database aaa contains schema a1, a2 and a3. user xx can query from >> >> sche