Re: [GENERAL] wildcard alias

On Fri, 2006-11-10 at 23:34 +0100, Martijn van Oosterhout wrote: > I don't know what your query or aliases have to do with joins, but if > you want to join two tables on all fields with the same name, you can > do a NATURAL JOIN. > > Have a nice day, > > On Fri, Nov 10, 2006 at 05:17:12PM -0500,

[GENERAL] Utility to Convert MS SQL Server to Postgres

Any recommondations for a util that helps with conversion of MS SQL Server databases to Postgres? Constraints, triggers, etc? Thanks -- View this message in context: http://www.nabble.com/Utility-to-Convert-MS-SQL-Server-to-Postgres-tf2611970.html#a7289969 Sent from the PostgreSQL - general mai

Re: [GENERAL] Request for replication advice

Brendan Jurd wrote: Why *does* Slony require a bi-directional connection to the subscriber? The data is travelling in one direction only ... what needs to come back the other way? So the slave can say "yes I got that data you can remove it from my TODO list" ? This seems to be getting rat

Re: [GENERAL] apparent wraparound

"George Pavlov" <[EMAIL PROTECTED]> writes: >> "George Pavlov" <[EMAIL PROTECTED]> writes: > 2006-11-08 12:38:34 PST [3739]: [3-1] LOG: could not truncate directory > "pg_multixact/members": apparent wraparound During crash recovery? >>> no crashes, just normal DB operation... >> >>

Re: [GENERAL] apparent wraparound

> "George Pavlov" <[EMAIL PROTECTED]> writes: > >> During crash recovery? > > no crashes, just normal DB operation... > > Hmm ... what is in pg_multixact/members/ again? Now there is only a file named 0010 the date on which changes about every 4-5 minutes or so. I only noticed the log even with

Re: [GENERAL] apparent wraparound

On Fri, 2006-11-10 at 15:21 -0800, George Pavlov wrote: > I see other posts on this log message before, but not clear to me how/if > they apply to me. Opinions appreciated. I am on 8.1.3 on Linux. I have a > log entry like this: > > 2006-11-08 12:38:34 PST [3739]: [3-1] LOG: could not truncate di

Re: [GENERAL] apparent wraparound

"George Pavlov" <[EMAIL PROTECTED]> writes: >> During crash recovery? > no crashes, just normal DB operation... Hmm ... what is in pg_multixact/members/ again? And what do you get from pg_controldata? regards, tom lane ---(end of broadcast)--

Re: [GENERAL] FK pointing to a VIEW

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10 Nov 2006, at 20:47, Olexandr Melnyk wrote: > While I agree in principle that such a thing should be > able to be done, it simply isn't possible. (in PostgreSQL, you can't > even add an index to a view, which a unique constraint would depend >

Re: [GENERAL] apparent wraparound

> During crash recovery? no crashes, just normal DB operation... ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] apparent wraparound

"George Pavlov" <[EMAIL PROTECTED]> writes: > I am on 8.1.3 on Linux. I have a > log entry like this: > 2006-11-08 12:38:34 PST [3739]: [3-1] LOG: could not truncate directory > "pg_multixact/members": apparent wraparound During crash recovery? If so, probably nothing to worry about, per this 8

[GENERAL] Automatically Creating INSERT/UPDATE/DELETE Rules on Views

I'm converting a large Oracle DB that uses hundreds of updatable views. ora2pg is quite useful, but it looks like it doesn't do anything to create the rules that are needed to make the views updatable. Under Oracle simple views like "select * from the_table" are automatically updatable, so the Ora

[GENERAL] apparent wraparound

I see other posts on this log message before, but not clear to me how/if they apply to me. Opinions appreciated. I am on 8.1.3 on Linux. I have a log entry like this: 2006-11-08 12:38:34 PST [3739]: [3-1] LOG: could not truncate directory "pg_multixact/members": apparent wraparound Nothing troub

Re: [GENERAL] wildcard alias

I don't know what your query or aliases have to do with joins, but if you want to join two tables on all fields with the same name, you can do a NATURAL JOIN. Have a nice day, On Fri, Nov 10, 2006 at 05:17:12PM -0500, Matthew Terenzio wrote: > > I suppose I should have named things differently b

[GENERAL] wildcard alias

I suppose I should have named things differently but is there a way to join two tables with a bunch of identical column names and rather than explicitly alias each column just use some sort of wildcard like: SELECT tablename.* AS alias.* OR do I have to name each column like: columnname as

Re: [GENERAL] Request for replication advice

On 11/11/06, Chris Browne <[EMAIL PROTECTED]> wrote: Let me point out one possible downside to using Slony-I log shipping; it may not be an issue for you, but it's worth observing... Log shipping works via serializing the subscription work done on a subscriber to files. Thus, you MUST have at l

Re: [GENERAL] Request for replication advice

[EMAIL PROTECTED] ("Brendan Jurd") writes: > On 11/11/06, Brad Nicholson <[EMAIL PROTECTED]> wrote: >> On Fri, 2006-11-10 at 15:07 -0500, Tom Lane wrote: >> > "Brendan Jurd" <[EMAIL PROTECTED]> writes: >> > > So, my question for the list is: is Slony + log shipping the direction >> > > I should be

Re: [GENERAL] Request for replication advice

On 11/11/06, Brad Nicholson <[EMAIL PROTECTED]> wrote: On Fri, 2006-11-10 at 15:07 -0500, Tom Lane wrote: > "Brendan Jurd" <[EMAIL PROTECTED]> writes: > > So, my question for the list is: is Slony + log shipping the direction > > I should be investigating, or is there something else out that I ou

Re: [GENERAL] FK pointing to a VIEW

> While I agree in principle that such a thing should be> able to be done, it simply isn't possible. (in PostgreSQL, you can't> even add an index to a view, which a unique constraint would depend > on). Agreed on that.But such an extension would require a view to be more than just SELECT.-

Re: [GENERAL] Request for replication advice

[EMAIL PROTECTED] (Tom Lane) writes: > Brad Nicholson <[EMAIL PROTECTED]> writes: >> On Fri, 2006-11-10 at 15:07 -0500, Tom Lane wrote: >>> Those are two different methods: you'd use one or the other, not both. > >> Slony has its own log shipping, I think that was what he was referring >> to. > > O

Re: [GENERAL] Request for replication advice

On Fri, 2006-11-10 at 15:16 -0500, Tom Lane wrote: > Brad Nicholson <[EMAIL PROTECTED]> writes: > > On Fri, 2006-11-10 at 15:07 -0500, Tom Lane wrote: > >> Those are two different methods: you'd use one or the other, not both. > > > Slony has its own log shipping, I think that was what he was refe

Re: [GENERAL] Request for replication advice

Brad Nicholson <[EMAIL PROTECTED]> writes: > On Fri, 2006-11-10 at 15:07 -0500, Tom Lane wrote: >> Those are two different methods: you'd use one or the other, not both. > Slony has its own log shipping, I think that was what he was referring > to. Oh, OK, I was thinking of the trigger-driven ver

Re: [GENERAL] Request for replication advice

On Fri, 2006-11-10 at 15:07 -0500, Tom Lane wrote: > "Brendan Jurd" <[EMAIL PROTECTED]> writes: > > So, my question for the list is: is Slony + log shipping the direction > > I should be investigating, or is there something else out that I ought > > to consider? > > Those are two different methods

Re: [GENERAL] Request for replication advice

"Brendan Jurd" <[EMAIL PROTECTED]> writes: > So, my question for the list is: is Slony + log shipping the direction > I should be investigating, or is there something else out that I ought > to consider? Those are two different methods: you'd use one or the other, not both. Slony-I is much the mo

Re: [GENERAL] Request for replication advice

On Sat, 2006-11-11 at 06:34 +1100, Brendan Jurd wrote: > So, my question for the list is: is Slony + log shipping the direction > I should be investigating, or is there something else out that I ought > to consider? My understanding of WAL-based replication is that the This is certainly the dire

Re: [GENERAL] Using GIN indexes on 8.2

On Fri, 2006-11-10 at 20:39 +0300, Teodor Sigaev wrote: > >> Use @>, <@ operations instead of @ and ~ > >> Look for discussions in -hackers for reasons of changing names > > > > Ah, many thanks. How about updating those web pages? :) > Now they are in core: > http://developer.postgresql.org/pgdocs

Re: [GENERAL] FK pointing to a VIEW

Sandro Dentella <[EMAIL PROTECTED]> schrieb: > Do I understad correctly that i cannot point a Foreign Key to a view? Which > is the rationale of this? A VIEW is simply a regular SELECT ..., a string that contains a SELECT. Question: How can you add a FK to a string? You can add a FK to a table,

[GENERAL] Request for replication advice

Hi all, Yes, it's yet another request for advice on replicating pgsql. I have been doing some research on this lately, and so far I am getting the impression that what I want is Slony + log shipping. The scenario is: * One master postgres database on the internal, which is being frequently upd

Re: [GENERAL] FK pointing to a VIEW

On 11/10/06, Sandro Dentella <[EMAIL PROTECTED]> wrote: Do I understad correctly that i cannot point a Foreign Key to a view? Which is the rationale of this? Blame the sql standard. Foreign keys are required to reference a table with a unique constraint, and you can't add a unique constraint t

[GENERAL] FK pointing to a VIEW

Do I understad correctly that i cannot point a Foreign Key to a view? Which is the rationale of this? TIA sandro *:-) test=# alter table mail_inviate test-#add constraint mail_inviate_fk test-#FOREIGN KEY (mittente) REFERENCES mail_view(mail_address) test-# ; ERROR: referenced relation

[GENERAL] Cached dataset

I have about 100 mostly static tables in my application. It takes about 1 minutes to download them through internet. So I think I need to cahce those tables in local hard drive. However, in this case refresh must be done before table access when those tables are changed in server. MS SQL .NET da

Re: [GENERAL] Which DatumGet ?

On Fri, Nov 10, 2006 at 05:30:09PM +0100, Enrico wrote: > In my table I have a field myfied defined by > > myfield numeric(20,5); > > Which kind of DatumGet macro I have to use? As an indirect type you want DatumGetPointer and cast it to numeric*. Have a nice day, -- Martijn van Oosterhout

Re: [GENERAL] Using GIN indexes on 8.2

Use @>, <@ operations instead of @ and ~ Look for discussions in -hackers for reasons of changing names Ah, many thanks. How about updating those web pages? :) Now they are in core: http://developer.postgresql.org/pgdocs/postgres/functions-array.html Pls, why don't you use tsearch2 with GIN

Re: [GENERAL] Problem with pg_dump

Ok - it is user error, my bad.  It looks like something bad happened during the restore, and indexes didn't get created.  I forgot that pg_dump creates indexes as upper case CREATE INDEX, and I was grepping for 'index', not 'INDEX'. sorry for the confusion, to be honest I panicked when the thought

Re: [GENERAL] Problem with pg_dump

On Friday 10 November 2006 08:37, "Alex Turner" <[EMAIL PROTECTED]> wrote: > Sure thing, I hope it's as simple as user error! > > #!/bin/sh > export DATE=`date +%Y%m%d` > > /usr/local/pgsql/bin/pg_dump -Upostgres -hlocalhost trend > > /backup/trend.dump.$DATE > > Thats pretty much it repeated for e

Re: [GENERAL] Problem with pg_dump

Alex Turner <[EMAIL PROTECTED]> schrieb: > Sure thing, I hope it's as simple as user error! > > #!/bin/sh > export DATE=`date +%Y%m%d` > > /usr/local/pgsql/bin/pg_dump -Upostgres -hlocalhost trend > /backup/ > trend.dump.$DATE > > Thats pretty much it repeated for each database. I just upgrade

Re: [GENERAL] Datum problem

Thanks for your answeres. -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now ...oh look, he already is [EMAIL PROTECTED] - Skype:sscotty71 http://www.linuxtime.it/enricopirozzi ---(end of broadcast)-

Re: [GENERAL] Problem with pg_dump

I would be happy to point someone to the dump file, it's about 500Meg thoughAlexOn 11/10/06, Alex Turner < [EMAIL PROTECTED]> wrote:Sure thing, I hope it's as simple as user error! #!/bin/shexport DATE=`date +%Y%m%d`/usr/local/pgsql/bin/pg_dump -Upostgres -hlocalhost trend > /backup/trend.dump.$DAT

Re: [GENERAL] Problem with pg_dump

Sure thing, I hope it's as simple as user error!#!/bin/shexport DATE=`date +%Y%m%d`/usr/local/pgsql/bin/pg_dump -Upostgres -hlocalhost trend > /backup/trend.dump.$DATEThats pretty much it repeated for each database.  I just upgraded to 8.1.5 to see if that would fix the problem, but it didn'tAlexO

[GENERAL] Which DatumGet ?

In my table I have a field myfied defined by myfield numeric(20,5); Which kind of DatumGet macro I have to use? Regards, Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now ...oh look, he already is [EMAIL PROTECTED] - Skype:sscotty71 h

Re: [GENERAL] Problem with pg_dump

On Fri, 2006-11-10 at 11:23 -0500, Tom Lane wrote: > "Alex Turner" <[EMAIL PROTECTED]> writes: > > Well yes - thats what I mean, the definition for the index. It's not > > dumping the index defs. It also looks like it's not dumping roles fully > > either. I was missing grants from the dump too.

Re: [GENERAL] Problem with pg_dump

"Alex Turner" <[EMAIL PROTECTED]> writes: > Well yes - thats what I mean, the definition for the index. It's not > dumping the index defs. It also looks like it's not dumping roles fully > either. I was missing grants from the dump too. [ raised eyebrow... ] Let's see a test case.

Re: [GENERAL] [PL/pgSQL] How should I use FOUND special variable. Documentation is little unclear for me

On 11/9/06, Jeremiasz Miedzinski <[EMAIL PROTECTED]> wrote: Now, I need to do the same action in PL/pgSQL. It's rather simple, but I don't know how to use FOUND variable described in documentation: FETCH retrieves the next row from the cursor into a target, which may be a row variable, a record

Re: [GENERAL] Database Mirroring Solution

If the delay between sites is unacceptable, then you most certainly do not want a synchronous replication system, because then everybody goes slow for all updates. So you'll need to figure out how you plan to deal with conflicts when each site updates the same row and the conflict is discov

Re: [GENERAL] Problem with pg_dump

Well yes - thats what I mean, the definition for the index.  It's not dumping the index defs.  It also looks like it's not dumping roles fully either.  I was missing grants from the dump too.Alex On 11/9/06, Brent Wood <[EMAIL PROTECTED]> wrote: A. Kretschmer wrote:> am  Thu, dem 09.11.2006, um 13:

Re: [GENERAL] Using GIN indexes on 8.2

On Nov 10, 2006, at 16:16 , Teodor Sigaev wrote: Alexander Staubo wrote: Two questions about GIN on 8.2. There's not much documentation about GIN, but this should be possible: create table foo (values text[]); create index foo_values_index on foo using gin (text); However, this then fai

Re: [GENERAL] Using GIN indexes on 8.2

Alexander Staubo wrote: Two questions about GIN on 8.2. There's not much documentation about GIN, but this should be possible: create table foo (values text[]); create index foo_values_index on foo using gin (text); However, this then fails saying the operator "@" does not exist: sele

[GENERAL] how & from where to start & admin pgsql on red hat ES 3

Hi Group! I am trying to work & connect php wirh PGSQL on Red Hat ES 3. I got some Important path like: /usr/share/pgsql/contrib /usr/include/pgsql /usr/bin But I don't know how to start/stop pgsql server, Insert data from client pgsql , view database files, admin database & configuration f

Re: [GENERAL] AutoVacuum on demand?

You might be able to do that using auto vacuum nap time setting...Thanks,---Shoaib MirEnterpriseDB (www.enterprisedb.com) On 11/10/06, Glen Parker <[EMAIL PROTECTED]> wrote: I would like a way to run the autovacuum daemon on demand periodically.   Every night at 2 AM, for example.Anybody know i

Re: [GENERAL] tsearch2() with data from other table

CREATE FUNCTION euits(int) RETURNS text AS 'select username || \' \' || firstname || \' \' || lastname from site_user where objectid = $1;' LANGUAGE SQL; CREATE TRIGGER site_item_fts BEFORE UPDATE OR INSERT ON site_item FOR EACH ROW EXECUTE PROCEDURE tsearch2(idxfti, name, keywords, keywords_cb

Re: [GENERAL] [PL/pgSQL] Commit every N rows. Is it possible ?

2006/11/9, Richard Huxton : It's not clear to me why your function does what it does anyway. I can'tsee why you wouldn't just do this as standard queries.As it was mentioned on http://orafaq.com/faqplsql.htm Contrary to popular believe, one should COMMIT less frequently within a

Re: [GENERAL] tsearch2() with data from other table

Teodor Sigaev skrev: CREATE FUNCTION euits(int) RETURNS text AS 'select username || \' \' || firstname || \' \' || lastname from site_user where objectid = $1;' LANGUAGE SQL; CREATE TRIGGER site_item_fts BEFORE UPDATE OR INSERT ON site_item FOR EACH ROW EXECUTE PROCEDURE tsearch2(idxfti, name,

Re: [GENERAL] AutoVacuum on demand?

Richard Broersma Jr wrote: > > Richard Broersma Jr wrote: > > >> Cron yes, vacuumdb no. I would like to AUTO vacuum periodically. > > > Just curious, what is auto_vacuum going to give that vacuumdb wont? > > Hmm, I thought this would be obvious. Vacuumdb just issues "VACUUM" > > commands. > > I

[GENERAL] Using GIN indexes on 8.2

Two questions about GIN on 8.2. There's not much documentation about GIN, but this should be possible: create table foo (values text[]); create index foo_values_index on foo using gin (text); However, this then fails saying the operator "@" does not exist: select * from foo where values

Re: [GENERAL] ECPG and multiple threads

On Fri, Nov 10, 2006 at 12:23:19AM -0800, Adam wrote: > Hi, > > I'm porting an embedded-SQL application to PostgreSQL so embedded sql > is a must for me. My application is multi-threaded. SQL queries are > used by several threads. The program keeps terminating unexpectedly in > deemingly "innocent

Re: [GENERAL] tsearch2() with data from other table

CREATE FUNCTION euits(int) RETURNS text AS 'select username || \' \' || firstname || \' \' || lastname from site_user where objectid = $1;' LANGUAGE SQL; CREATE TRIGGER site_item_fts BEFORE UPDATE OR INSERT ON site_item FOR EACH ROW EXECUTE PROCEDURE tsearch2(idxfti, name, keywords, keywords_cb

Re: [GENERAL] "stopping" a single database in a cluster

> Is it possible to stop a single database, like it is with Oracle? Our > oracle admin asked this for FS backups, if there are 3 dbs (in > separate tablespaces) then there seems no reason why this couldn't be > possible... is it possible? No, this is not possible, because they are all serverd by t

[GENERAL] tsearch2() with data from other table

Hi, I have a table with items. One field is site_user, which fk:s the user row that owns the item. There are a few fields i throw to tsearch2() via an index right now, but one user wanted his name to be in the search as well. So, what I would want to do is: CREATE FUNCTION euits(int) RETURNS te

Re: [GENERAL] Database Mirroring Solution

[EMAIL PROTECTED] (Gideon) wrote: > Thanks for the quick reply. > > We basicaly need to run a database servers in 2 different > towns. Now there will be update's and selects and both need > to be in sync with each other. Aswell as if / when database in > town 1 goes down ... we need to be able to s

Re: [GENERAL] Database Mirroring Solution

>>> We basicaly need to run a database servers in 2 different >>> towns. Now there will be update's and selects and both need >>> to be in sync with each other. Aswell as if / when database in >>> town 1 goes down ... we need to be able to switch to the database >>> in town 2 for emergency purpos

[GENERAL] SSL Certificate Check

Hi, I'm trying to install a SSL certificate. psql correctly shows: SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256) how can I check what certificate it has sent? Or what key it uses? Thank you Markus ---(end of broadcast)--- TIP 2: Don't

Re: [GENERAL] Database Mirroring Solution

Richard Huxton wrote: Gideon wrote: Thanks for the quick reply. No problem, but don't forget to cc: the list. We basicaly need to run a database servers in 2 different towns. Now there will be update's and selects and both need to be in sync with each other. Aswell as if / when database in t

Re: [GENERAL] ECPG and multiple threads

> I'm porting an embedded-SQL application to PostgreSQL so embedded sql > is a must for me. My application is multi-threaded. SQL queries are > used by several threads. The program keeps terminating unexpectedly in > deemingly "innocent" places. > I figured out that ecpg library can be responsible

Re: [GENERAL] Database Mirroring Solution

Gideon wrote: Thanks for the quick reply. No problem, but don't forget to cc: the list. We basicaly need to run a database servers in 2 different towns. Now there will be update's and selects and both need to be in sync with each other. Aswell as if / when database in town 1 goes down ... we

Re: [GENERAL] Database Mirroring Solution

On Fri, 10 Nov 2006 13:42:14 +0200 Gideon <[EMAIL PROTECTED]> wrote: > We basicaly need to run a database servers in 2 different > towns. I suppose you can't use an HA solution. :( Regards Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now .

Re: [GENERAL] Database Mirroring Solution

Thanks for the quick reply. We basicaly need to run a database servers in 2 different towns. Now there will be update's and selects and both need to be in sync with each other. Aswell as if / when database in town 1 goes down ... we need to be able to switch to the database in town 2 for emergenc

Re: [GENERAL] Database Mirroring Solution

On Fri, 10 Nov 2006 13:24:18 +0200 Gideon <[EMAIL PROTECTED]> wrote: > Is anyone aware of any mirroring > solutions for > postgres ? Have yoy tried HeartBeat + DRBD for an HA solution? Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now ...

Re: [GENERAL] Linux vs. FreeBSD

> > I had best performance on FreeBSD with his file system. > > > > Look at this link. > > http://www.postgresql.org/files/documentation/books/aw_pgsql/hw_performance/node11.html > > Is this still accurate 3.75 years later? I don't know if is still accurate now, but in my work I've seen that po

Re: [GENERAL] Database Mirroring Solution

Gideon wrote: Hi I have done some research and it seems there are no active mirroring solutions for postgresql 8 and above. I did see Slony but I need Master to Master functionality and not only Master to Slave/'s. That's not "mirroring", it's known as "multi-master replication". Mirroring

Re: [GENERAL] Linux vs. FreeBSD

Bart McFarling wrote: We are installing a new Postgresql server, it will not run anything else but postgresql. We are currently looking at moving from a RHEL 4.0 system to FreeBSD. Does one OS offer better performace over the other when running postgresql? I'd guess the crucial thing will be

[GENERAL] Database Mirroring Solution

Hi I have done some research and it seems there are no active mirroring solutions for postgresql 8 and above. I did see Slony but I need Master to Master functionality and not only Master to Slave/'s. Is anyone aware of any mirroring solutions for postgres ? TIA Gideon -

Re: [GENERAL] "stopping" a single database in a cluster

Anton Melser wrote: Hi, Is it possible to stop a single database, like it is with Oracle? Our oracle admin asked this for FS backups, if there are 3 dbs (in separate tablespaces) then there seems no reason why this couldn't be possible... is it possible? No - the transaction log (WAL) is shared

[GENERAL] "stopping" a single database in a cluster

Hi, Is it possible to stop a single database, like it is with Oracle? Our oracle admin asked this for FS backups, if there are 3 dbs (in separate tablespaces) then there seems no reason why this couldn't be possible... is it possible? Cheers Antoine ps. If this isn't possible, what experiences do

Re: [GENERAL] Linux vs. FreeBSD

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/10/06 02:24, Enrico wrote: > On Tue, 7 Nov 2006 10:12:57 -0600 > "Bart McFarling" <[EMAIL PROTECTED]> wrote: > >> We are installing a new Postgresql server, it will not run anything else >> but postgresql. We are currently looking at moving from

Re: [GENERAL] postgres at startup

Michael McCloskey wrote: Postgres is starting automatically for me at startup. When I boot up my machine and then check the running processes I see postmaster.exe and 4 postgres processes. How can I stop this? I don't want Postgres starting up automatically. Thanks. -Michael For XP/2000/2003

Re: [GENERAL] Logging in postgresql.conf - no SQL statements are logged

am Fri, dem 10.11.2006, um 10:48:12 +0100 mailte Nico Grubert folgendes: > Dear list members, > > I would like to enable logging and write every SQL command that is > executed in a logfile so I modified the "postgresql.conf" file in order > ... > Did I miss something? Yes, change this line: #

[GENERAL] Logging in postgresql.conf - no SQL statements are logged

Dear list members, I would like to enable logging and write every SQL command that is executed in a logfile so I modified the "postgresql.conf" file in order to log everything. I restarted the Postgres SQL server. Unfortunately, no SQL statements are logged in the logfile. Here is a snippet

[GENERAL] ECPG and multiple threads

Hi, I'm porting an embedded-SQL application to PostgreSQL so embedded sql is a must for me. My application is multi-threaded. SQL queries are used by several threads. The program keeps terminating unexpectedly in deemingly "innocent" places. I figured out that ecpg library can be responsible for t

Re: [GENERAL] Linux vs. FreeBSD

On Tue, 7 Nov 2006 10:12:57 -0600 "Bart McFarling" <[EMAIL PROTECTED]> wrote: > We are installing a new Postgresql server, it will not run anything else > but postgresql. We are currently looking at moving from a RHEL 4.0 > system to FreeBSD. > > Does one OS offer better performace over the othe

Re: [GENERAL] postgres at startup

> Postgres is starting automatically for me at startup. > > When I boot up my machine and then check the running > processes I see postmaster.exe and 4 postgres processes. > > How can I stop this? > > I don't want Postgres starting up automatically. You don't tell, but I guess that you use Win