[GENERAL] shared_buffer advice

I have a server with Dual-Core 4 cpu and 32 GB RAM. This is the database server. Only Postgresql 8.1 is running on it with multiple databases. How should I plan for shared_buffers and effective cache size? Any idea please.

Re: [GENERAL] Re: Error on Windows server could not open relation base/xxx/xxx Permission denied

John, > It's the user created by the one-click installer. I believe it owns the > postgres data directory and is used to start the server. Other than that, > the intention is for this user to have no other file privileges. The default > is "postgres" but it could be anything. > > doing the defaul

Re: [GENERAL] shared_buffer advice

On Mon, Jun 14, 2010 at 1:36 AM, AI Rumman wrote: > I have a server with Dual-Core 4 cpu and 32 GB RAM. > This is the database server. Only Postgresql 8.1 is running on it with > multiple databases. > > How should I plan for shared_buffers and effective cache size? > Any idea please. Well, that r

Re: [GENERAL] Re: Error on Windows server could not open relation base/xxx/xxx Permission denied

On Mon, Jun 14, 2010 at 05:17, John T. Dow wrote: > I was talking to a friend (Joe Newcomer) who said that Unix doesn't have > mandatory file locks and he guessed that the empty, system, read only files I > saw at my client's site were unix-like lock files. They are not. They are regular relati

Re: [GENERAL] shared_buffer advice

On Mon, Jun 14, 2010 at 1:36 AM, AI Rumman wrote: > I have a server with Dual-Core 4 cpu and 32 GB RAM. > This is the database server. Only Postgresql 8.1 is running on it with > multiple databases. > > How should I plan for shared_buffers and effective cache size? > Any idea please. Note that ef

Re: [GENERAL] Re: Error on Windows server could not open relation base/xxx/xxx Permission denied

On Mon, Jun 14, 2010 at 2:35 AM, Magnus Hagander wrote: > On Mon, Jun 14, 2010 at 05:17, John T. Dow wrote: >> Apparently the problem boils down to this question: how did some of the >> files get set to be system and read only? > > Yes. That would be very interesting to know. PostgreSQL never >

Re: [GENERAL] Re: Error on Windows server could not open relation base/xxx/xxx Permission denied

On Mon, Jun 14, 2010 at 10:57, Scott Marlowe wrote: > On Mon, Jun 14, 2010 at 2:35 AM, Magnus Hagander wrote: >> On Mon, Jun 14, 2010 at 05:17, John T. Dow wrote: >>> Apparently the problem boils down to this question: how did some of the >>> files get set to be system and read only? >> >> Yes.

Re: [GENERAL] Partial indexes instead of partitions

> For "inserts" I do not see the reason > why > it would be better to use index partitioning because AFAIK > b-tree > would behave exactly the same in both cases. no, when the index gets very big inserting random values gets very slow. But still, my approach doesn't work because I thought Postg

Re: [GENERAL] checkpoint spikes

Hi Martijn, hi Greg, thanks you very much for your help. We finally got rid of these annoying spikes. First we tried to set checkpoint_segments = 3# before 16 checkpoint_timeout = 5min # before: 60min which didn't really help. we had the same spikes but more often. Then we tried to lo

Re: [GENERAL] How to show the current schema or search path in the psql PROMP

On 14 Jun 2010, at 2:02, Clemens Schwaighofer wrote: > Right now I added two simple wrappers in my .psqlrc > > \set shsh 'SHOW search_path;' > \set setsh 'SET search_path TO' > > So I can at least set and check the schema more quickly. That only saves you a few key-presses though. Is your psql

Re: [GENERAL] How to show the current schema or search path in the psql PROMP

On Mon, Jun 14, 2010 at 19:10, Alban Hertroys wrote: > On 14 Jun 2010, at 2:02, Clemens Schwaighofer wrote: > >> Right now I added two simple wrappers in my .psqlrc >> >> \set shsh 'SHOW search_path;' >> \set setsh 'SET search_path TO' >> >> So I can at least set and check the schema more quickly.

Re: [GENERAL] How to show the current schema or search path in the psql PROMP

On 14 Jun 2010, at 12:14, Schwaighofer Clemens wrote: > On Mon, Jun 14, 2010 at 19:10, Alban Hertroys > wrote: >> On 14 Jun 2010, at 2:02, Clemens Schwaighofer wrote: >> >>> Right now I added two simple wrappers in my .psqlrc >>> >>> \set shsh 'SHOW search_path;' >>> \set setsh 'SET search_path

[GENERAL] Is there a way to backup Postgres via SQL commands?

Are there SQL commands that can do a backup over a client connection, rather than from the command line like pgsql etc? By that I mean some kind of SELECT commands that can retrieve the database's content as SQL commands that can be replayed to a server to restore it, rather than something that sa

Re: [GENERAL] Is there a way to backup Postgres via SQL commands?

In response to Frank Church : > Are there SQL commands that can do a backup over a client connection, > rather than from the command line like pgsql etc? > > By that I mean some kind of SELECT commands that can retrieve the > database's content as SQL commands that can be replayed to a server to >

Re: [GENERAL] Partial indexes instead of partitions

On 14 June 2010 13:24, Leonardo F wrote: >> For "inserts" I do not see the reason >> why >> it would be better to use index partitioning because AFAIK >> b-tree >> would behave exactly the same in both cases. > > no, when the index gets very big inserting random values gets > very slow. Hm, inter

[GENERAL] What are the minimal files required to backup a postgresql database

I need to package the ability to backup a PostgreSQL database in my application? I obviously need to add pg_dump.exe to the package, and the dlls required are listed below, 15/08/2007 15:4112,288 comerr32.dll 15/08/2007 15:41 139,264 gssapi32.dll 15/08/2007 15:41

Re: [GENERAL] Partial indexes instead of partitions

On Mon, Jun 14, 2010 at 5:24 AM, Leonardo F wrote: > > For "inserts" I do not see the reason > > why > > it would be better to use index partitioning because AFAIK > > b-tree > > would behave exactly the same in both cases. > > no, when the index gets very big inserting random values gets > very

Re: [GENERAL] Partial indexes instead of partitions

On Mon, Jun 14, 2010 at 7:27 AM, David Wilson wrote: > > > On Mon, Jun 14, 2010 at 5:24 AM, Leonardo F wrote: >> >> > For "inserts" I do not see the reason >> > why >> > it would be better to use index partitioning because AFAIK >> > b-tree >> > would behave exactly the same in both cases. >> >>

Re: [GENERAL] Partial indexes instead of partitions

On Mon, Jun 14, 2010 at 8:38 AM, Peter Hunsberger < peter.hunsber...@gmail.com> wrote: > > > Can you define acceptable? IIRC the OP is looking for 20,000+ inserts / > sec. > > > He's actually only looking for 2k inserts/sec. With a battery backed controller I can sustain that, yes. That's also on

Re: [GENERAL] Is there a way to backup Postgres via SQL commands?

On 14 Jun 2010, at 13:28, Frank Church wrote: > Are there SQL commands that can do a backup over a client connection, > rather than from the command line like pgsql etc? No. > By that I mean some kind of SELECT commands that can retrieve the > database's content as SQL commands that can be repla

Re: [GENERAL] Is there a way to backup Postgres via SQL commands?

On 14/06/2010 12:28, Frank Church wrote: > Are there SQL commands that can do a backup over a client connection, > rather than from the command line like pgsql etc? No, not that I'm aware of. > By that I mean some kind of SELECT commands that can retrieve the > database's content as SQL commands

[GENERAL] Advice on contingency plan for DAS array with separate local WAL drives

Recently migrated to a shiny new 8.4.4 postgres instancedata stored on attached storage array. Transaction logs stored on 2 local mirrored drives (local to the database server itself) for best performance. While we are replicating (using slony) to our DR site, our first-choice plan (in the

[GENERAL] Re: Moving a live production database to different server and postgres release

The database is < 10GB and currently on a postgres version 8.2.15 on a BSD system and moving to postgres version 8.4.4 on a windows 2008 server. The adding of data is continuous but in small quantities, totaling at about 20MB a day. After your post I had a look at Slony-I, which, according to it w

Re: [GENERAL] Advice on contingency plan for DAS array with separate local WAL drives

On 6/14/10 8:05 AM, "Jeff Amiel" wrote: > What is recommended in terms of prep/switchover in this instance? Should we > be rsyncing or using built-in wal-log shipping of these transaction logs to > our stand-by server? Simply pop out these drives and hand-move them to the > standby-server? (a

Re: [GENERAL] What are the minimal files required to backup a postgresql database

On 14 Jun 2010, at 14:20, Frank Church wrote: > I need to package the ability to backup a PostgreSQL database in my > application? What are you trying to accomplish by that? > I obviously need to add pg_dump.exe to the package, and the dlls > required are listed below, You can check what dll's

Re: [GENERAL] Re: Moving a live production database to different server and postgres release

On 14/06/2010 14:09, Ulas Albayrak wrote: > After your post I had a look at Slony-I, which, according to it web > page, requires postgres 8.3 or later, so I guess that won't work. That > leaves Bucardo: will it work on a Windows system? AIUI, the Slony-I 2.x branch requires PG 8.3+, but the 1.x b

Re: [GENERAL] shared_buffer advice

AI Rumman wrote: I have a server with Dual-Core 4 cpu and 32 GB RAM. This is the database server. Only Postgresql 8.1 is running on it with multiple databases. How should I plan for shared_buffers and effective cache size? Set shared_buffers very low--at most 128MB--because you're running Po

Re: [GENERAL] Hosting without pgcrypto functions. There are other solutions?

On Sun, Jun 13, 2010 at 4:37 PM, Andre Lopes wrote: > Hi, > > I have an account in A2Hosting.com, and I'm developing some functions that > deal with encryption. > > A2Hosting.com don't have available the function "digest()" > > [code] > ERROR:  function digest(unknown, unknown) does not exist > LI

Re: [GENERAL] Advice on contingency plan for DAS array with separate local WAL drives

Jeff Amiel wrote: Recently migrated to a shiny new 8.4.4 postgres instancedata stored on attached storage array. Transaction logs stored on 2 local mirrored drives (local to the database server itself) for best performance. Have you benchmarked that this really helps? Splitting the W

Re: [GENERAL] Hosting without pgcrypto functions. There are other solutions?

Have you talked to A2 about this? They are very good about installing things. John On Jun 14, 2010, at 3:20 PM, Merlin Moncure wrote: On Sun, Jun 13, 2010 at 4:37 PM, Andre Lopes wrote: Hi, I have an account in A2Hosting.com, and I'm developing some functions that deal with encrypti

Re: [GENERAL] Re: Moving a live production database to different server and postgres release

OK, I see. Does this mean I need to install Slony-I 1.x on both systems or is different versions of Slony-I, say a 2.x and a 1.x, compatible? The reason I'm asking is because the new server db will be part of a permanent postgres replication system in the future and installing a newer verision of

Re: [GENERAL] Re: Moving a live production database to different server and postgres release

On 14/06/2010 14:33, Ulas Albayrak wrote: > OK, > > I see. Does this mean I need to install Slony-I 1.x on both systems or > is different versions of Slony-I, say a 2.x and a 1.x, compatible? The > reason I'm asking is because the new server db will be part of a > permanent postgres replication sy

Re: [GENERAL] Re: Moving a live production database to different server and postgres release

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 ... > After your post I had a look at Slony-I, which, according to it web > page, requires postgres 8.3 or later, so I guess that won't work. That > leaves Bucardo: will it work on a Windows system? The daemon itself cannot run on a Windows sys

Re: [GENERAL] Partial indexes instead of partitions

On Mon, Jun 14, 2010 at 08:27:49AM -0400, David Wilson wrote: > On Mon, Jun 14, 2010 at 5:24 AM, Leonardo F wrote: > > > For "inserts" I do not see the reason why it would be better to > > > use index partitioning because AFAIK b-tree would behave exactly > > > the same in both cases. > > > > no,

Re: [GENERAL] Is there a way to backup Postgres via SQL commands?

On 14/06/2010 9:05 PM, Raymond O'Donnell wrote: On 14/06/2010 12:28, Frank Church wrote: Are there SQL commands that can do a backup over a client connection, rather than from the command line like pgsql etc? No, not that I'm aware of. By that I mean some kind of SELECT commands that can ret

Re: [GENERAL] What are the minimal files required to backup a postgresql database

On 14/06/2010 9:14 PM, Alban Hertroys wrote: On 14 Jun 2010, at 14:20, Frank Church wrote: I need to package the ability to backup a PostgreSQL database in my application? What are you trying to accomplish by that? I obviously need to add pg_dump.exe to the package, and the dlls required ar

Re: [GENERAL] Is there a way to backup Postgres via SQL commands?

On Mon, Jun 14, 2010 at 7:28 AM, Frank Church wrote: > Are there SQL commands that can do a backup over a client connection, > rather than from the command line like pgsql etc? > > By that I mean some kind of SELECT commands that can retrieve the > database's content as SQL commands that can be re

[GENERAL] Trigger get dissabled

Hi, I am using postgre SQL 8.3 on centos, My case is Suppose I a databse ABC (In this database I have few enabled trigger) and I am making abc.tar as a dump file using pg_dump utility. Now I am restoring abc.tar using pg_restore on another machine . Up to now every thing is fine but the trigg

Re: [GENERAL] Unable to (re) start PostgreSQL 8.4.4/WinXP

The pg_log files contain, rather inexplicably: 2010-06-14 09:47:32 IST LOG: invalid IP mask "trust": Unknown host 2010-06-14 09:47:32 IST CONTEXT: line 74 of configuration file "E:/Data/PostgreSQL/8.4/data/pg_hba.conf" 2010-06-14 09:47:32 IST FATAL: could not load pg_hba.conf 2010-06-14 09:4

Re: [GENERAL] Unable to (re) start PostgreSQL 8.4.4/WinXP

kunalashar wrote: The pg_log files contain, rather inexplicably: 2010-06-14 09:47:32 IST LOG: invalid IP mask "trust": Unknown host 2010-06-14 09:47:32 IST CONTEXT: line 74 of configuration file "E:/Data/PostgreSQL/8.4/data/pg_hba.conf" 2010-06-14 09:47:32 IST FATAL: could not load pg_hba.con

Re: [GENERAL] Trigger get dissabled

On Mon, Jun 14, 2010 at 3:52 PM, Gaurav K Srivastav wrote: > Hi, > > I am using postgre SQL 8.3 on centos, > > My case is Suppose I a databse ABC (In this database I have few enabled > trigger) and I am making abc.tar as a dump file using pg_dump utility. > Now I am restoring abc.tar using pg_r

[GENERAL] Silent installer in Windows

Hi folks, I want to install ps silentely in Windows how I can do it? what's needed arguments? Sorry I'm still a newbie Ps I read pginstaller doc about silent installing but I noticed that pginstaller no longer available as mention

[GENERAL] Unable to install pg in Win (MVR error)

Hi All, As shown in the following screenshot I couldn't install pg in Windows because it couldn't install Microsoft VC++ Runtime! How I can fix this issue? PS I didn't find any problem during using pg in kubuntu it worked smoothly within 10 seconds. -- Best Regards Muhammad Bashir A

[GENERAL] thoughts about constraint trigger

Heyho! I was trying to implement a deferred NOT NULL constraint using a deferred constraint trigger (on update and insert of this row) because some values would be filled in later during the transaction, after the initial part of the record has been filled. I asked myself if a type of deferred

[GENERAL] IMMUTABLE columns in tables?

Heyho! (Ok, seems to be feature wish day ...) I was wondering if others would find an IMMUTABLE (or whatever) column constraint useful as well. Semantics would (obviously?) be to disallow changing the value of this column after insert. I realize that this is possible via triggers, and with th

Re: [GENERAL] Unable to install pg in Win (MVR error)

On Mon, Jun 14, 2010 at 7:22 PM, M. Bashir Al-Noimi wrote: > Hi All, > > > As shown in the following screenshot I couldn't install pg in Windows > because it couldn't install Microsoft VC++ Runtime! > > > How I can fix this issue? > If you already have the right version (VC++ 2005 SP1) of the

Re: [GENERAL] Silent installer in Windows

In the One-Click Installer for PostgreSQL use the CLI option, --mode unattended for more options see --help. On 6/15/10 12:45 AM, M. Bashir Al-Noimi wrote: Hi folks, I want to install ps silentely in Windows how I can do it? what's needed arguments? Sorry I'm still a newbie Ps I read

Re: [GENERAL] GSS Authentication

Thanks for the help. In response to your questions, I did make sure the service name was right. klist -k on the keytab file gives: KVNO Principal --    3 POSTGRES/hostname.domain@domain.com I replac

Re: [GENERAL][SOLVED] Silent installer in Windows

Thanks Sachin On 14/06/2010 08:55 م, Sachin Srivastava wrote: In the One-Click Installer for PostgreSQL use the CLI option, --mode unattended for more options see --help. On 6/15/10 12:45 AM, M. Bashir Al-Noimi wrote: Hi folks, I want to install ps silentely in Windows how I can do it? wha

Re: [GENERAL] Unable to install pg in Win (MVR error)

On 14/06/2010 08:43 م, Dave Page wrote: On Mon, Jun 14, 2010 at 7:22 PM, M. Bashir Al-Noimi wrote: Hi All, As shown in the following screenshot I couldn't install pg in Windows because it couldn't install Microsoft VC++ Runtime!

Re: [GENERAL] Unable to install pg in Win (MVR error)

When you run the installer without specifying "--install_runtimes 0", What is the error code returned by the MS VC++ Runtime installer. You can check that in the log file (%TEMP%\bitrock_installer_.log). On 6/15/10 2:17 AM, M. Bashir Al-Noimi wrote: On 14/06/2010 08:43 م, Dave Page wrote:

Re: [GENERAL] Cognitive dissonance

t...@sss.pgh.pa.us (Tom Lane) writes: > Peter Eisentraut writes: >> On lör, 2010-06-12 at 11:18 +0200, John Gage wrote: >>> A one file html version would be a godsend. > >> I've committed a build target for that now. Use 'make postgres.html' in >> doc/src/sgml/. > > Huh, is that actually worth a

Re: [GENERAL] Re: Moving a live production database to different server and postgres release

On Mon, Jun 14, 2010 at 7:33 AM, Ulas Albayrak wrote: > OK, > > I see. Does this mean I need to install Slony-I 1.x on both systems or > is different versions of Slony-I, say a 2.x and a 1.x, compatible? The > reason I'm asking is because the new server db will be part of a > permanent postgres re

Re: [GENERAL] Re: Moving a live production database to different server and postgres release

On Mon, Jun 14, 2010 at 7:09 AM, Ulas Albayrak wrote: > The database is < 10GB and currently on a postgres version 8.2.15 on a > BSD system and moving to postgres version 8.4.4 on a windows 2008 > server. The adding of data is continuous but in small quantities, > totaling at about 20MB a day. Is

Re: [GENERAL] table partition or index

On Sun, Jun 13, 2010 at 9:14 AM, AI Rumman wrote: > For how many records I should go for a table partition instead of using just > index? > Any idea please. I concur with Stephen. We tend to split our tables when they exceed 100 million rows *if* they are experiencing performance issues, and tar

Re: [GENERAL] Unable to install pg in Win (MVR error)

On Mon, Jun 14, 2010 at 8:47 PM, M. Bashir Al-Noimi wrote: > On 14/06/2010 08:43 م, Dave Page wrote: > > > > On Mon, Jun 14, 2010 at 7:22 PM, M. Bashir Al-Noimi wrote: > >> Hi All, >> >> >> As shown in the following screenshot I couldn't install pg in Windows >> because it couldn't install Micr

Re: [GENERAL] Re: Moving a live production database to different server and postgres release

On 14 Jun 2010, at 22:22, Scott Marlowe wrote: > Is there are good reason to go to Windows instead of a new BSD system? > Windows is a known mediocre performer for postgres. I was wondering that too. I assume the good reasons wear ties. Alban Hertroys -- If you can't see the forest for the tree

Re: [GENERAL] GSS Authentication

One other thing possibly worth noting I tried to connect to the Postgres DB using pgAdmin III and it gives a very similar error to the test perl program that I wrote: Error connecting to the server: FATAL: accepting GSS security context failed DETAIL: Miscellaneous failure: Unknown cod

Re: [GENERAL] Unable to install pg in Win (MVR error)

On 14/06/2010 11:16 م, Dave Page wrote: On Mon, Jun 14, 2010 at 8:47 PM, M. Bashir Al-Noimi > wrote: On 14/06/2010 08:43 م, Dave Page wrote: On Mon, Jun 14, 2010 at 7:22 PM, M. Bashir Al-Noimi mailto:ad...@mbnoimi.net>> wrote: Hi All,

Re: [GENERAL] Unable to install pg in Win (MVR error)

Wow, I catch installer bug. This problem related to executing .vbs files because of that whole installing process failed. In the attachment will find that Bitrock installer unable to run .vbs script because in my PC I specified .vbs file association with notepad. For that I could install pg s

Re: [GENERAL] Re: Error on Windows server could not open relation base/xxx/xxx Permission denied

Today we were able to look at the first computer's files. About 20 - 30 of them were marked system, hidden, read only. We cleared the attribute bits with the ATTRIB command and the database now appears to be normal. We were able to do a backup (that failed before) and were able to paste in 50K

[GENERAL] DDL partitioning with insert trigger issue

Hello, I am running PG 8.3. and following the guide found at http://www.postgresql.org/docs/current/static/ddl-partitioning.html I have followed the steps outlined here nearly exactly with regards to using an insert trigger to call a function to insert data into the child partition. I

[GENERAL] Tracking SQLs that update data

Hi I'm having some issues with a code base where several different programs are updating one "status" column in the DB with their code. Mostly this is working, but in some cases the status column in a DB is getting updated when it shouldn't have been, and we're trying to locate which program did i

Re: [GENERAL] Unable to install pg in Win (MVR error)

On Mon, Jun 14, 2010 at 11:33 PM, M. Bashir Al-Noimi wrote: > Wow, I catch installer bug. > > This problem related to executing .vbs files because of that whole > installing process failed. > > In the attachment will find that Bitrock installer unable to run .vbs > script because in my PC I speci

Re: [GENERAL] DDL partitioning with insert trigger issue

On Mon, Jun 14, 2010 at 4:46 PM, mark wrote: > Hello, > > I am running PG 8.3. and following the guide found at > http://www.postgresql.org/docs/current/static/ddl-partitioning.html > > > I have followed the steps outlined here nearly exactly with regards to using > an insert trigger to call a fun

Re: [GENERAL] Tracking SQLs that update data

On Mon, Jun 14, 2010 at 5:55 PM, Phoenix Kiula wrote: > Hi > > I'm having some issues with a code base where several different > programs are updating one "status" column in the DB with their code. > Mostly this is working, but in some cases the status column in a DB is > getting updated when it s

Re: [GENERAL] Unable to install pg in Win (MVR error)

On 15/06/2010 02:26 ?, Dave Page wrote: On Mon, Jun 14, 2010 at 11:33 PM, M. Bashir Al-Noimi mailto:ad...@mbnoimi.net>> wrote: Wow, I catch installer bug. This problem related to executing .vbs files because of that whole installing process failed. In the attachment will fi

Re: [GENERAL] Tracking SQLs that update data

On 06/14/2010 06:55 PM, Phoenix Kiula wrote: Hi I'm having some issues with a code base where several different programs are updating one "status" column in the DB with their code. Mostly this is working, but in some cases the status column in a DB is getting updated when it shouldn't have been,

[GENERAL] Does enterprisedb.com down?

Hi folks, I tried to visit enterprisedb.com yesterday and today but I couldn't the browser gave me this error message: Network Error (tcp_error) A communication error occurred: "Operation timed out" The Web Server may

Re: [GENERAL] Does enterprisedb.com down?

It works fine for me. I would suggest using http://downforeveryoneorjustme.com/ or something similar to check in the future. -- Adam Alkins || http://www.rasadam.com On 14 June 2010 22:45, M. Bashir Al-Noimi wrote: > Hi folks, > > > I tried to visit enterprisedb.com yesterday and today but

Re: [GENERAL] Tracking SQLs that update data

Scott Marlowe writes: > On Mon, Jun 14, 2010 at 5:55 PM, Phoenix Kiula > wrote: >> My question: how can I set up a "RULE" so that when a specific column >> is updated, a separate table also logs which update SQL was issued? > It's far easier to adjust the logging. Or, if you're worried about a

Re: [GENERAL] Does enterprisedb.com down?

What's going on! http://downforeveryoneorjustme.com/ gave me the following stupid message: Forbidden Your client does not have permission to get URL / from this server. (Client IP address: 213.178.224.178) You are accessing this page from a forbidden country. and enterprisedb.com still unavai

Re: [GENERAL] Does enterprisedb.com down?

I ran the IP on http://whatismyipaddress.com/blacklist-check and it is not blacklisted. On Jun 15, 2010, at 6:53 AM, M. Bashir Al-Noimi wrote: Now I wondering does postgresql forbids my country or not?, is it open source or something else? -- Sent via pgsql-general mailing list (pgsql-ge

[GENERAL] CFP for Surge Scalability Conference 2010

We're excited to announce Surge, the Scalability and Performance Conference, to be held in Baltimore on Sept 30 and Oct 1, 2010. The event focuses on case studies that demonstrate successes (and failures) in Web applications and Internet architectures. Robert Treat will be presenting one of his P

Re: [GENERAL] Does enterprisedb.com down?

John Gage wrote: I ran the IP on http://whatismyipaddress.com/blacklist-check and it is not blacklisted. On Jun 15, 2010, at 6:53 AM, M. Bashir Al-Noimi wrote: Now I wondering does postgresql forbids my country or not?, is it open source or something else? maybe an ISP between point A a

Re: [GENERAL] Does enterprisedb.com down?

On 15/06/2010 06:00 ?, John Gage wrote: I ran the IP on http://whatismyipaddress.com/blacklist-check and it is not blacklisted. Actually I _*suspect*_ that pg takes same policy of sf.net where sf.net forbids open source projects to specific countries as mentioned in the following links (for tha

Re: [GENERAL] Does enterprisedb.com down?

May be you will be able to get one that is not blocked from the ftp sites list? I don't know if the rules applicable to main server are automatically applied to the mirror sites too. http://wwwmaster.postgresql.org/download/mirrors-ftp Regards, Jayadevan DISCLAIMER: "The information in thi

Re: [GENERAL] Does enterprisedb.com down?

On Mon, Jun 14, 2010 at 11:21 PM, M. Bashir Al-Noimi wrote: > So I wish to get a clarification about this issue, does pg forbids my > country? is it still open source? Can you get to postgresql.org? Cause that is pg. enterprisedb is NOT pg, it is a commercial company that provides a lot of serv

Re: [GENERAL] Enforcing password standards

On Fri, Jun 11, 2010 at 10:40:29AM -0700, DM wrote: >Thanks everyone, >I will wait for Postgres 9.0 to implement this feature then. Thanks The contrib module supports enforcement of only some of the things you've listed you want. For other items on your list (notably renewal), you're bette

Re: [GENERAL] thoughts about constraint trigger

On 15/06/10 02:33, Adrian von Bidder wrote: > Heyho! > > I was trying to implement a deferred NOT NULL constraint using a deferred > constraint trigger (on update and insert of this row) because some values > would be filled in later during the transaction, after the initial part of > the recor

Re: [GENERAL] Does enterprisedb.com down?

All the mirrors work except the enterprisedb.com itself. On Tue, Jun 15, 2010 at 7:50 AM, Jayadevan M wrote: > May be you will be able to get one that is not blocked from the ftp sites > list? I don't know if the rules applicable to main server are > automatically applied to the mirror sites too.

Re: [GENERAL] Does enterprisedb.com down?

On Tue, Jun 15, 2010 at 07:21, M. Bashir Al-Noimi wrote: > On 15/06/2010 06:00 ص, John Gage wrote: > > I ran the IP on http://whatismyipaddress.com/blacklist-check and it is not > blacklisted. > > Actually I suspect that pg takes same policy of sf.net where sf.net forbids > open source projects to