[GENERAL] Upgrading from 8.3RC2 to release

Hi, Should the usual dump/restore cycle be performed during the upgrade on FreeBSD? Any minor backward-incompatible changes one should be aware of? Thank you for the best work. ---(end of broadcast)--- TIP 5: don't forget to increase your free s

Re: [GENERAL] Question for Postgres 8.3

If you want to support multiple encodings, the only safe locale choice is (and always has been) C. I should be ashamed for asking this, but would someone care to tell me how encoding differs from locale? My postgresql FreeBSD rcNG script reads: postgresql_initdb_flags=${postgresql_initdb_fla

Re: [GENERAL] Question for Postgres 8.3

On 02/05/2008 03:38 PM, Hiroshi Saito wrote: > Hi. > > This reply is very glad for me!:-) > However, There is still a locale problem. If I use an EUC database on an UTF8 system? Well I will try out and see if it breaks everything. > Anyway, thanks > > Regards, > Hiroshi Saito > > - Ori

Re: [GENERAL] Question for Postgres 8.3

Hi. This reply is very glad for me!:-) However, There is still a locale problem. Anyway, thanks Regards, Hiroshi Saito - Original Message - From: "Clemens Schwaighofer" <[EMAIL PROTECTED]> I'm surprised your clients haven't been screaming about bogus sorting and upper/lowercasin

Re: [GENERAL] PostgreSQL 8.3.0 RPMs are available for download

On Feb 4, 2008, at 7:30 PM, Devrim GÜNDÜZ wrote: The PostgreSQL RPM Building Project has released RPMs for 8.3.0 and they are available in main FTP site and its mirrors. Hi, I am interested in deploying PG 8.3.0 on one of our in-house appliance product that is managed using RPMs and open

Re: [GENERAL] Question for Postgres 8.3

I'm surprised your clients haven't been screaming about bogus sorting and upper/lowercasing behavior. Umm, This is a mere information. (Since you dislike, this may be a noise.?) As for upper/lower. It does not change, even if uses which locale in us Japanese. (there is nothing with the alphabe

Re: [GENERAL] failed to build any 8-way joins: SQLSTATE: XX000 on PostgreSQL 8.2.6

Tom Lane wrote: If increasing join_collapse_limit to 9 or more makes the problem go away for you, that would be additional evidence that what you are seeing is the same problem already diagnosed. That might be a usable workaround for you until 8.2.7 comes out... Thank Tom. That worked aroun

[GENERAL] Simplest syntax (or a UI?) to rename columns and sequences and constraints (etc)?

Is there a SQL/ALTER (pg proprietary or otherwise) syntax that uniformly changes the names off all object tied to a column when that column name is changed? Or can anyone recommend a UI that does this? For example in a table 'foo' I have a 'rowid' (pk and auto increment) and I choose to rename

Re: [GENERAL] failed to build any 8-way joins: SQLSTATE: XX000 on PostgreSQL 8.2.6

Ken Johanson <[EMAIL PROTECTED]> writes: > Sorry Tom, I just missed you and responded on list, also asking if there > were a test implied in adjusting the query. Anyway, here is trimmed-down > DDL. Well, if I just load this script into an empty DB in 8.2-CVS-tip and then run the given query, it

Re: [GENERAL] failed to build any 8-way joins: SQLSTATE: XX000 on PostgreSQL 8.2.6

Tom Lane wrote: Please see if this patch fixes it for you: http://archives.postgresql.org/pgsql-committers/2008-01/msg00164.php If not, we'll need a self-contained test case. Please pardon my non-awareness, what comprises a test case for this; is DDL sufficent? I'm electing to go that route

Re: [GENERAL] Question for Postgres 8.3

If you want to support multiple encodings, the only safe locale choice is (and always has been) C. If you doubt this, troll the archives for awhile --- for example, searching for locale+encoding in pgsql-bugs should provide plenty of amusing reading matter. This is most interesting. I think

Re: [GENERAL] PostgreSQL/PHP Application Server

> No, I was suggesting an approach that might address your requirement > for integration with other authentication systems. > Actually what I really need is the Oracle 9i + Oracle Directory Service functionality (e.g. nss_ldap for PostgreSQL). That combined with Oracle Label Security (OLS) --

Re: [GENERAL] failed to build any 8-way joins: SQLSTATE: XX000 on PostgreSQL 8.2.6

Ken Johanson <[EMAIL PROTECTED]> writes: > Hi all, I've seen other mentions of this happening but this instance is > with a newer server version than the ones that had a patch applied. Please see if this patch fixes it for you: http://archives.postgresql.org/pgsql-committers/2008-01/msg00164.php

Re: [GENERAL] PostgreSQL/PHP Application Server

On Feb 2, 2008, at 9:40 PM, Brian A. Seklecki (Mobile) wrote: On Thu, 2008-01-24 at 13:10 -0500, John DeSoi wrote: . The user/login system is extensible, so you could write your own. I'm not sure if I follow: Are you suggestion that the CMS system, Drupal, is an example of an application se

[GENERAL] failed to build any 8-way joins: SQLSTATE: XX000 on PostgreSQL 8.2.6

Hi all, I've seen other mentions of this happening but this instance is with a newer server version than the ones that had a patch applied. Basically, 8 LEFT JOINs, and removing any one of them stop the symptom. I'll provide more data if the query in itself doesn't not indicate what's causing

Re: [GENERAL] question about PANIC: hash table "Shared Buffer Lookup Table" corrupted

"bh yuan" <[EMAIL PROTECTED]> writes: > I use Postgresql 7.4.19 wiht 8G memory on Redhat5 x86_64. > And I modify the postgresql.conf file, > when I set > shared_buffers = 786432# min 16, at least 7.4 does not support more than 2Gb (or maybe 4Gb, I forget) of shared memory. Further

[GENERAL] postgresql-8.3.0-1-binaries-no-installer: gssapi32.dll missed ?

When I try to execute psql.exe or pg_ctl.exe, I got an error: can't find gssapi32.dll. see the attachment: http://www.nabble.com/file/p15282929/pgsql-8.3.0-noinstaller-win32-missing-gssapi32.dll.png pgsql-8.3.0-noinstaller-win32-missing-gssapi32.dll.png Does anyone encountered the same problem?

[GENERAL] question about PANIC: hash table "Shared Buffer Lookup Table" corrupted

hi I use Postgresql 7.4.19 wiht 8G memory on Redhat5 x86_64. And I modify the postgresql.conf file, when I set shared_buffers = 786432# min 16, at least max_connections*2, 8KB each (6G) and import data. [ PANIC: hash table "Shared Buffer Lookup Table" corrupted ] occur. I set the

Re: [GENERAL] Question for Postgres 8.3

Hi. - Original Message - From: "Clemens Schwaighofer" <[EMAIL PROTECTED]> hi, on the page: in point E.1.2.3: * Disallow database encodings that are inconsistent with the server's locale setting (Tom) does this mean, i

Re: [GENERAL] Question for Postgres 8.3

On 02/05/2008 11:38 AM, Tom Lane wrote: > Clemens Schwaighofer <[EMAIL PROTECTED]> writes: >> * Disallow database encodings that are inconsistent with the server's >> locale setting (Tom) > >> does this mean, if my server LOCALE is for example UTF-8.en_US, and I want >> to create a EUC_JP databa

Re: [GENERAL] Reload only specific databases from pg_dumpall

Or, for the heck of it: sed -n -e '/DATABASE smarlowe/p' -e '141,334p' test.sql > clean.sql ;} Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm ---(end of broadcast)

Re: [GENERAL] Question for Postgres 8.3

Clemens Schwaighofer <[EMAIL PROTECTED]> writes: > * Disallow database encodings that are inconsistent with the server's > locale setting (Tom) > does this mean, if my server LOCALE is for example UTF-8.en_US, and I want > to create a EUC_JP database it gets rejected? do I missunderstand that?

Re: [GENERAL] Reload only specific databases from pg_dumpall

Nice... Can this be reliably put into a script? The script would take only the DB name as parameter. And one gotcha I woud look out for is to see the CREATE DB's template= is nothing but template0, else warn the user that the DB may not be reliably restored. Best regards, On Feb 4, 2008 6:03 PM,

[GENERAL] Question for Postgres 8.3

hi, on the page: in point E.1.2.3: * Disallow database encodings that are inconsistent with the server's locale setting (Tom) does this mean, if my server LOCALE is for example UTF-8.en_US, and I want to create a EUC_JP database i

Re: [GENERAL] Reload only specific databases from pg_dumpall

On Feb 4, 2008 7:10 PM, Guido Neitzer <[EMAIL PROTECTED]> wrote: > On 04.02.2008, at 18:00, Gurjeet Singh wrote: > > > I understand it all needs a little bit of 'vi' wizardry, (or > > whichever editor you are using). Also, as with all open-source > > suggestions, do not rely on this procedure until

Re: [GENERAL] Reload only specific databases from pg_dumpall

Well... I assumed that'd be the case; production dumps are not small... this calls for some scripting stuff; the script should basically the steps mentioned above, and you will have a trimmed down version of the dump file... :) But again, the script should be fast enough to make this additional st

[GENERAL] PostgreSQL 8.3.0 RPMs are available for download

PostgreSQL New RPM Sets 2008-02-04 Versions: 8.3.0 Set labels: 8.3.0-1PGDG - - Release Info

Re: [GENERAL] Universal libpq.a ?

"Dave Page" <[EMAIL PROTECTED]> writes: > On Feb 4, 2008 6:25 PM, Tom Lane <[EMAIL PROTECTED]> wrote: >> "Dave Page" <[EMAIL PROTECTED]> writes: >>> The Mac build of EDB Postgres is universal throughout, >> >> Yeah? How painful is it? We've had more than one request to enable >> universal builds

Re: [GENERAL] Reload only specific databases from pg_dumpall

On 04.02.2008, at 18:00, Gurjeet Singh wrote: I understand it all needs a little bit of 'vi' wizardry, (or whichever editor you are using). Also, as with all open-source suggestions, do not rely on this procedure until you understand what and how it does what it does. Sure, the only probl

Re: [GENERAL] Reload only specific databases from pg_dumpall

I understand it all needs a little bit of 'vi' wizardry, (or whichever editor you are using). Also, as with all open-source suggestions, do not rely on this procedure until you understand what and how it does what it does. Best regards, On Feb 4, 2008 4:39 PM, Gurjeet Singh <[EMAIL PROTECTED]> wr

Re: [GENERAL] REINDEX on large DB vs. DROP INDEX/CREATE INDEX

Wes <[EMAIL PROTECTED]> writes: > The reason for the huge change in the vacuum time is that the indexes are > scanned in index order instead of disk order. I understand that is fixed in > 8.2 or 8.3 (don't recall which I saw it in), but have never gotten > confirmation from anyone on that. Yeah,

Re: [GENERAL] Reload only specific databases from pg_dumpall

Sorry couldn't respond earlier... Yeah, there's no -f option to pg_dumpall, I confused it with pg_dump's -F option. Since the output of dumpall is plain SQL, since and you would use psql to restore the DB, there's no command line option to execute only a part of the script. Long story short: you

Re: [GENERAL] REINDEX on large DB vs. DROP INDEX/CREATE INDEX

On 2/4/08 9:53 AM, "Vivek Khera" <[EMAIL PROTECTED]> wrote: > what you need to do is compare the relpages from the pg_class table > for that index before and after. > > if you didn't get much disk space back, make sure you have no long > running transactions that may have kept some older files op

Re: [GENERAL] encoding does not match server's locale

mikie <[EMAIL PROTECTED]> writes: > However, I used different encodings in previous 8.2 within a cluster > and now I don't know how to restore my databases. initdb in C locale. regards, tom lane ---(end of broadcast)--- TIP

Re: [GENERAL] Postgres with daemontools or similar

On 05/02/2008, Chuck D. <[EMAIL PROTECTED]> wrote: > would never know if there was an issue. I was also looking into monit. I don't know what others recommend, but I'd be violently opposed to the automatic re-starting for the very reason you mention above. Monitoring it via monit, nagios or whic

Re: [GENERAL] Out of Memory errors while running pg_dump

I wrote: > ... I'm wondering a bit why > CacheMemoryContext has so much free space in it, but even if it had none > you'd still be at risk. I tried to reproduce this by creating a whole lot of trivial tables and then pg_dump'ing them: create table t0 (f1 int primary key); insert into t0 values(0)

[GENERAL] Postgres with daemontools or similar

Greetings everyone. I would like to know what the correct position is on the use of Postgres with DJB's daemontools or other monitoring prgrams? I tried to set it up the other day and was successful in getting it to start and log, and even refresh the config files, but I could not get it to sh

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

Em Monday 04 February 2008 14:38:31 Csaba Nagy escreveu: > Why don't you go ahead and create those special lists and make general > collect all of them ? Some sort of hierarchy of lists... if doable at > all, that could make everybody happy... That's an excellent idea. -- Jorge Godoy <[E

[GENERAL] encoding does not match server's locale

Hi, I just wanted to upgrade from 8.2 to 8.3. So I performed pg_dump_all and now when I try to feed psql with the dump I have problems with some databases: psql:c:/Program Files/PostgreSQL/8.2/bin/dump.sql:32: ERROR: encoding LATIN2 does not match server's locale Polish_Poland.1250 OK, I have alr

Re: [GENERAL] Out of Memory errors while running pg_dump

Erik Jones <[EMAIL PROTECTED]> writes: > On Feb 4, 2008, at 3:26 PM, Tom Lane wrote: >> Are you sure the postmaster is being launched >> under ulimit unlimited? > ulimit -a gives: One possible gotcha is that ulimit in an interactive shell isn't necessarily the same environment that an init script

Re: [GENERAL] Out of Memory errors while running pg_dump

On Feb 4, 2008, at 3:26 PM, Tom Lane wrote: Erik Jones <[EMAIL PROTECTED]> writes: Sure. I've attached an archive with the full memory context and error for each. Note that I'm already 99% sure that this is due to our exorbitantly large relation set which is why I think pg_dump's catalog que

Re: [GENERAL] Out of Memory errors while running pg_dump

Erik Jones <[EMAIL PROTECTED]> writes: > Sure. I've attached an archive with the full memory context and > error for each. Note that I'm already 99% sure that this is due to > our exorbitantly large relation set which is why I think pg_dump's > catalog queries are running out of work_mem (c

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

Lewis Cunningham wrote: --- Gregory Stark <[EMAIL PROTECTED]> wrote: pgsql-hackers pgsql-users There really aren't any other groups of people. "people who want to talk about There are hackers (contribute to PostgreSQL), DBAs (administer the database), Developers (write application to

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

--- Gregory Stark <[EMAIL PROTECTED]> wrote: > > pgsql-hackers > pgsql-users > > There really aren't any other groups of people. "people who want to > talk about There are hackers (contribute to PostgreSQL), DBAs (administer the database), Developers (write application to interact with the dat

Re: [GENERAL] Universal libpq.a ?

On Feb 4, 2008, at 1:25 PM, Tom Lane wrote: "Dave Page" <[EMAIL PROTECTED]> writes: The Mac build of EDB Postgres is universal throughout, Yeah? How painful is it? We've had more than one request to enable universal builds. regards, tom lane Here is a config file

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > On Mon, 04 Feb 2008 19:48:16 + > > -performance is a little bit tougher because it may be a -hacker issue > or an -admin issue. In my experience it is really a carbon copy of -general. I wasn't even aware of -admin before. Is it just "administra

Re: [GENERAL] "pg_ctl: cannot be run as root"

"Andrej Ricnik-Bay" <[EMAIL PROTECTED]> writes: > I don't know MacOS very well, and it's been a while that I last > had my hands on MacOS X (>2 years). Are you saying that > you use MacOS as user root by default, rather than as a non > privileged account? Certainly not. The problem was the "sudo

Re: [GENERAL] Alternative to tableoids?

[EMAIL PROTECTED] wrote: Hi, what's an alternative to tableoids? As I've learned today they are not consistant across pg_dump/restore. I need to point to (lots of dynamically added) tables and used tableoids before. Are there other solutions to point to tables besides using tableoids or wast

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification -- wind it up, please.

Everyone, > > I would junk pgsql-sql, pgsql-ports, pgsql-performance, pgsql-novice > > and redirect them all to pgsql-general and pgsql-docs, > > pgsql-interfaces, and pgsql-bugs and send them all to -hackers. Speaking of keeping discussions on topic: this discussion is taking off in a tangent a

Re: [GENERAL] Out of Memory errors while running pg_dump

On Feb 4, 2008, at 1:27 PM, Tom Lane wrote: We'd need to see more details to really give decent advice. Exactly what queries and exactly what was the error message (in particular I'm wondering how large the failed request was)? Which PG version? Can you get the memory context dump out of the

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

On Mon, February 4, 2008 2:48 pm, Gregory Stark wrote: > [*] "New newsgroups are formed not on The Field Of Dreams theory- "if you > build it, they will come"- but on the Brooklyn Dodgers theory- > "dammit, > there's too many teams in this city: someone move out!"--Charles > Seaton It ap

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

On Mon, 04 Feb 2008 19:48:16 + Gregory Stark <[EMAIL PROTECTED]> wrote: > > Right, I believe that is a valid argument. I think the real > > problem is that as a community we are not diligent in pushing > > people to the contextually specific lists we already have. > I would junk pgsql-sql, pg

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

Erik Jones <[EMAIL PROTECTED]> writes: > On Feb 4, 2008, at 11:55 AM, Lewis Cunningham wrote: >> "Joshua D. Drake" <[EMAIL PROTECTED]> writes: >>> I don't agree in the least, I was actually going to suggest we add a >>> new one for relational design questions. I like many lists that are >>> context

Re: [GENERAL] "pg_ctl: cannot be run as root"

On 05/02/2008, Stefan Schwarzer <[EMAIL PROTECTED]> wrote: > But strange enough, I only can start the postgres server from time to > time, normally when I have freshly restarted the machine. Now for > example, I did some changes to the postgresql.conf file, and when > trying to restart the postgres

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > On Mon, 4 Feb 2008 12:31:05 -0600 > Erik Jones <[EMAIL PROTECTED]> wrote: > >> The sole argument I'd have against that, and I think it's a good >> one, is that just seeing the plethora of different topics moving >> through pgsql-general has been a ke

Re: [GENERAL] backup tableoids (pg_class.oid) ?

Alvaro Herrera <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] wrote: >> my db structure relays on the OIDs of tables (stored as OIDs of >> pg_class). > Probably it would be a better idea to store that as type regclass > instead of OIDs. I think that will take care of the dump part of the > probl

Re: [GENERAL] postgresql book - practical or something newer?

On Feb 4, 2008 6:12 PM, Greg Smith <[EMAIL PROTECTED]> wrote: > How hard would it be to clone the configuration of the developer's wiki > and make a new page like it for this purpose, something like > userdocs.postgresql.org? We intentionally have not done that as we wanted to ensure that all docu

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

On Feb 4, 2008 6:37 PM, Hiroshi Saito <[EMAIL PROTECTED]> wrote: > Hi. > > MSVCR80.dll which the binary of 8.3 refers to is this. > C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6b128700\MSVCR80.dll > I tried again in the beautiful environment which does not have 8.0.

Re: [GENERAL] commit fails, rollback needed?

[EMAIL PROTECTED] wrote: > Hi, > > when committing a transaction returns with an error: Do I have to > rollback the transaction in this case? No; it is already rolled back. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, In

Re: [GENERAL] Out of Memory errors while running pg_dump

Erik Jones <[EMAIL PROTECTED]> writes: > Hello, this past weekend I received a couple of Out of Memory errors > while running pg_dump for two different selects against the > catalogs, one with pg_get_viewdef() and the other with one of the > pg_index join pg_class left join pg_depend queries

Re: [GENERAL] Universal libpq.a ?

On Feb 4, 2008 6:25 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Dave Page" <[EMAIL PROTECTED]> writes: > > The Mac build of EDB Postgres is universal throughout, > > Yeah? How painful is it? We've had more than one request to enable > universal builds. There was fair bit of pain getting it to wor

[GENERAL] Alternative to tableoids?

Hi, what's an alternative to tableoids? As I've learned today they are not consistant across pg_dump/restore. I need to point to (lots of dynamically added) tables and used tableoids before. Are there other solutions to point to tables besides using tableoids or wasting disk space using the st

Re: [GENERAL] Reload only specific databases from pg_dumpall

On 04.02.2008, at 10:41, Gurjeet Singh wrote: What was the output format option used (-f option) ? Was it the plain-text (SQL) or custom format? I cannot see a -f option on pg_dumpall. This is the command: pg_dumpall > `date "+%y-%m-%d"`.sql I just want to use an older file from a dump to r

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

On Mon, 4 Feb 2008 12:31:05 -0600 Erik Jones <[EMAIL PROTECTED]> wrote: > The sole argument I'd have against that, and I think it's a good > one, is that just seeing the plethora of different topics moving > through pgsql-general has been a key factor to exposing me to new > topics as well as havi

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

--- Erik Jones <[EMAIL PROTECTED]> wrote: > On Feb 4, 2008, at 11:55 AM, Lewis Cunningham wrote: > > > > > I'd like to have many lists also. There are so many messages in > > general that I have a hard time keeping up. I would like to be > able > > to just pick and choose those topics that int

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

On Mon, Feb 04, 2008 at 06:52:42AM -0800, Selena Deckelmann wrote: > Having a separate TLD actually increases the visibility of the effort > from a search engine perspective. Having just come from the domain name industry, I can report that that's only sort of true. Did you "taste" this domain fo

[GENERAL] commit fails, rollback needed?

Hi, when committing a transaction returns with an error: Do I have to rollback the transaction in this case? Felix ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

Hi. MSVCR80.dll which the binary of 8.3 refers to is this. C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6b128700\MSVCR80.dll I tried again in the beautiful environment which does not have 8.0.50727.762 in the environment of XP-SP2. Then, It was fine. I can't reme

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

On Feb 4, 2008, at 9:37 AM, Raymond O'Donnell wrote: There's at least one website out there that offers DLLs for download, but I have no idea whether this is legal or not. Can anyone comment? It's the C runtime. IIRC that's one of the redistributables, so it's OK to distribute. Cheers,

Re: [GENERAL] Universal libpq.a ?

"Dave Page" <[EMAIL PROTECTED]> writes: > The Mac build of EDB Postgres is universal throughout, Yeah? How painful is it? We've had more than one request to enable universal builds. regards, tom lane ---(end of broadcast)-

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

On Feb 4, 2008, at 11:55 AM, Lewis Cunningham wrote: --- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote: On Mon, 04 Feb 2008 12:18:55 + Gregory Stark <[EMAIL PROTECTED]> wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: I was going to suggest pruning the mailing lists down to just 3-4

[GENERAL] free ETL tool using postgreSQL, new major release

Dear all, A graphical and simple ETL tool for files using postgreSQL under Windows exists, it is call Benetl. Is working with .txt or .csv files. You can find and freely download it at : www.benetl.net This version brings the ability to use Benetl as an "evolved" loader for your postgreSQL datab

Re: [GENERAL] postgresql book - practical or something newer?

On Mon, 4 Feb 2008, Dave Page wrote: On Feb 4, 2008 3:48 PM, vincent <[EMAIL PROTECTED]> wrote: So, let's do it community-style: wiki. Thats what techdocs is for. http://www.postgresql.org/docs/techdocs Feel free to write new articles or improve what is there already. Techdocs is a function

Re: [GENERAL] [OT] "advanced" database design (long)

Jorge Godoy <[EMAIL PROTECTED]> writes: > Em Monday 04 February 2008 07:03:47 Dawid Kuroczko escreveu: >> Well, but PostgreSQL's NULLs occupy almost no space, or rather a bit of >> space, that is one bit exactly. ;-) I am pretty much sure that >> storage-wise looking NULLs >> are more efficient.

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

--- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote: > On Mon, 04 Feb 2008 12:18:55 + > Gregory Stark <[EMAIL PROTECTED]> wrote: > > > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > > > > I was going to suggest pruning the mailing lists down to just 3-4 > > already. The last thing we need to b

Re: [GENERAL] PGSQL ERROR: FATAL: terminating connection due to administrator command

"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes: > I have a PostgreSQL 8.2.6 on FreeBSD 6.3 (but the described behavior > appears during several earlier minor versions as well) - which powers a > php based web application. What I experience is the message (below) > which appears during the first

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

On Feb 4, 2008 9:36 AM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Josh Berkus escribió: > > > So, I'm in favor of a separate list, but think that having a separate > > domain is a mistake. The separate domain says "this is a Drake and Selena > > effort and not a community effort" to those not in

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

There's at least one website out there that offers DLLs for download, but I have no idea whether this is legal or not. Can anyone comment? Ray. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED]

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

Josh Berkus escribió: > So, I'm in favor of a separate list, but think that having a separate > domain is a mistake. The separate domain says "this is a Drake and Selena > effort and not a community effort" to those not involved. Which is also what postgresqlconference.org and planetpostgresql

Re: [GENERAL] Reload only specific databases from pg_dumpall

What was the output format option used (-f option) ? Was it the plain-text (SQL) or custom format? Best regards On Feb 4, 2008 2:45 AM, Guido Neitzer <[EMAIL PROTECTED]> wrote: > Hi. > > Is it possible to reload only specific databases from a file created > by pg_dumpall? > > Thanks, > cug > > -

Re: [GENERAL] PGSQL ERROR: FATAL: terminating connection due to administrator command

[EMAIL PROTECTED] wrote: > Alvaro Herrera wrote: >> It's not unlikely that the server is crashing. This should not happen. >> Please examine the logs and let us know what you find. >> >> If it's indeed crashing, we would like to see a more complete report >> (possibly including a backtrace from a

Re: [GENERAL] backup tableoids (pg_class.oid) ?

[EMAIL PROTECTED] wrote: > Hi, > > my db structure relays on the OIDs of tables (stored as OIDs of > pg_class). Probably it would be a better idea to store that as type regclass instead of OIDs. I think that will take care of the dump part of the problem, at least. It's likely that there will b

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

On Mon, 4 Feb 2008 09:11:52 -0800 Josh Berkus <[EMAIL PROTECTED]> wrote: > So, I'm in favor of a separate list, but think that having a separate > domain is a mistake. The separate domain says "this is a Drake and > Selena effort and not a community effort" to those not involved. Selena isn't i

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

Hi. - Original Message - From: "Dave Page" <[EMAIL PROTECTED]> So, is there some reason the runtimes might not install in non-English versions of Windows? We're using the Windows Installer merge module as per Microsoft's recommendations. Surely your examination is passed. Therfore,

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

On Feb 4, 2008 3:38 PM, Hiroshi Saito <[EMAIL PROTECTED]> wrote: > Hi. > > It seems that MSVCR80.dll is not registered to InstallFinalize on the problem > of the timing of an installer. > It is not found at the time of initdb. Therefore, please before install this. > http://www.microsoft.com/downl

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

> I agree except for that last bit. Search is huge and relying only on > word-of-mouth is silly when we have plenty of people who know how to > optimize. This is completely the wrong argument to be having. Search engine issues are important only *after* you have a certification exam and progra

[GENERAL] Out of Memory errors while running pg_dump

Hello, this past weekend I received a couple of Out of Memory errors while running pg_dump for two different selects against the catalogs, one with pg_get_viewdef() and the other with one of the pg_index join pg_class left join pg_depend queries). Is it work_mem I should be increasing wit

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

Hi. Umm, Please investigate msm under the following. C:\Program Files\Common Files\Merge Modules Microsoft_VC80_CRT_x86.msm Please investigate the date and size of that.? Regards, Hiroshi Saito - Original Message - From: "Hermann Muster" <[EMAIL PROTECTED]> Konbanwa Hiroshi-san,

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

On Feb 4, 2008 7:07 AM, Gregory Stark <[EMAIL PROTECTED]> wrote: > "Selena Deckelmann" <[EMAIL PROTECTED]> writes: > > > On Feb 4, 2008 4:27 AM, Dave Page <[EMAIL PROTECTED]> wrote: > > > >> Even a new domain seems odd to me - if this is to be official, then > >> surely it should be under postgresq

Re: [GENERAL] loading files into tables

On Mon, 4 Feb 2008 17:21:00 +0100 "Pau Marc Munoz Torres" <[EMAIL PROTECTED]> wrote: > Ok > > I'm tryint to execute > > copy local from "/path" with delimiter "\t"; > > and I get the following errors > > ERROR: must be superuser to COPY to or from a file. > > Can I do something simil

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

On Mon, 2008-02-04 at 08:31 -0800, Joshua D. Drake wrote: > On Mon, 04 Feb 2008 12:18:55 + > Gregory Stark <[EMAIL PROTECTED]> wrote: > > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > > I was going to suggest pruning the mailing lists down to just 3-4 > > already. The last thing we need to b

Re: [GENERAL] I can't restart postgres

Thanks for the help. I use the pg_resetxlog and the database start again. Now I have other problem. I try to view a table using the command select and I have an error and I can't view the table. I wrote the following line in the terminal: htpoweron=# select * from example_table; (where e

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

Konbanwa Hiroshi-san, thanks for your fast reply. I installed the Microsoft Visual C++ 2005 SP1 Redistributable Package (x86) before running the PostgreSQL 8.3 setup. However, the PostgreSQL installation does still not find the msvcr80.dll. It seems, that the PostgreSQL setup has to be adjus

Re: [GENERAL] postgresql book - practical or something newer?

On Feb 4, 2008 3:31 PM, Tom Hart <[EMAIL PROTECTED]> wrote: > > Christopher Browne wrote: > > On Jan 31, 2008 4:40 PM, Guy Rouillier <[EMAIL PROTECTED]> wrote: > > > >> Robert Treat wrote: > >> > >> > >>> Just so you know, I approached OReally about writing a PostgreSQL > >>> Cookbook, > >>> and t

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

On Mon, 04 Feb 2008 12:18:55 + Gregory Stark <[EMAIL PROTECTED]> wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > > > Guys, with respect this thread does nothing for us unless it is on > > the certification list. > > Do we really need a separate mailing list for every thread? It's >

Re: [GENERAL] loading files into tables

Ok I'm tryint to execute copy local from "/path" with delimiter "\t"; and I get the following errors ERROR: must be superuser to COPY to or from a file. Can I do something similar to it without being superuser? for a Tab delimiter, should i use "\t" character? Thanks Pau 2008/2/4

Re: [GENERAL] [OT] "advanced" database design (long)

On Mon, Feb 04, 2008 at 10:49:51AM +0100, Masse Jacques wrote: > Hello [much garbage including HTML trimmed.] Please set your mail client to text-only. HTML does not make your point better, and it annoys the heck out of people whose mail readers use text. > This model is known as Entity-Value-A

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

On Monday 04 February 2008 09:52, Selena Deckelmann wrote: > On Feb 4, 2008 4:27 AM, Dave Page <[EMAIL PROTECTED]> wrote: > > Even a new domain seems odd to me - if this is to be official, then > > surely it should be under postgresql.org. > > Having a separate TLD actually increases the visibility

Re: [GENERAL] postgresql book - practical or something newer?

On Feb 4, 2008 3:48 PM, vincent <[EMAIL PROTECTED]> wrote: > So, let's do it community-style: wiki. Lots of people have a little time > to write a small piece, all we need is a few good men (or women) to > oversee the whole thing. Thats what techdocs is for. http://www.postgresql.org/docs/techdo

Re: [GENERAL] loading files into tables

Hi, Le lundi 04 février 2008, Pau Marc Munoz Torres a écrit : > I'm an ex-mysql user, i know there was a sentence in mysql that was > > load data local infile "somefile.txt" into table "sometable; > > I'm trying to do something similar in postgresql, can someone help me? COPY manual entry

  1   2   >