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.
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 default
On Mon, Jun 14, 2010 at 1:36 AM, AI Rumman rumman...@gmail.com 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.
On Mon, Jun 14, 2010 at 05:17, John T. Dow j...@johntdow.com 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
On Mon, Jun 14, 2010 at 1:36 AM, AI Rumman rumman...@gmail.com 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.
On Mon, Jun 14, 2010 at 2:35 AM, Magnus Hagander mag...@hagander.net wrote:
On Mon, Jun 14, 2010 at 05:17, John T. Dow j...@johntdow.com 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
On Mon, Jun 14, 2010 at 10:57, Scott Marlowe scott.marl...@gmail.com wrote:
On Mon, Jun 14, 2010 at 2:35 AM, Magnus Hagander mag...@hagander.net wrote:
On Mon, Jun 14, 2010 at 05:17, John T. Dow j...@johntdow.com wrote:
Apparently the problem boils down to this question: how did some of the
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 Postgresql
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
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
On Mon, Jun 14, 2010 at 19:10, Alban Hertroys
dal...@solfertje.student.utwente.nl 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
On 14 Jun 2010, at 12:14, Schwaighofer Clemens wrote:
On Mon, Jun 14, 2010 at 19:10, Alban Hertroys
dal...@solfertje.student.utwente.nl 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
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
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
On 14 June 2010 13:24, Leonardo F m_li...@yahoo.it 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,
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
On Mon, Jun 14, 2010 at 5:24 AM, Leonardo F m_li...@yahoo.it 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
On Mon, Jun 14, 2010 at 7:27 AM, David Wilson david.t.wil...@gmail.com wrote:
On Mon, Jun 14, 2010 at 5:24 AM, Leonardo F m_li...@yahoo.it 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
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
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 replayed
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
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 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
On 6/14/10 8:05 AM, Jeff Amiel becauseimj...@yahoo.com 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
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 an
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
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
On Sun, Jun 13, 2010 at 4:37 PM, Andre Lopes lopes80an...@gmail.com 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
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
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
lopes80an...@gmail.com wrote:
Hi,
I have an account in A2Hosting.com, and I'm developing some
functions
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
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 system
-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
On Mon, Jun 14, 2010 at 08:27:49AM -0400, David Wilson wrote:
On Mon, Jun 14, 2010 at 5:24 AM, Leonardo F m_li...@yahoo.it 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,
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
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
On Mon, Jun 14, 2010 at 7:28 AM, Frank Church voi...@googlemail.com 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
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
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
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.conf
On Mon, Jun 14, 2010 at 3:52 PM, Gaurav K Srivastav gaurav...@gmail.comwrote:
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
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
http://pginstaller.projects.postgresql.org/silent.html but I noticed
that pginstaller no longer available as
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
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
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
On Mon, Jun 14, 2010 at 7:22 PM, M. Bashir Al-Noimi ad...@mbnoimi.netwrote:
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
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
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
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?
On 14/06/2010 08:43 , Dave Page wrote:
On Mon, Jun 14, 2010 at 7:22 PM, M. Bashir
Al-Noimi ad...@mbnoimi.net wrote:
Hi All,
As shown in the
following screenshot I couldn't install pg in Windows because it
couldn't install Microsoft VC++ Runtime!
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_somenumber.log).
On 6/15/10 2:17 AM, M. Bashir Al-Noimi wrote:
On 14/06/2010 08:43 , Dave
t...@sss.pgh.pa.us (Tom Lane) writes:
Peter Eisentraut pete...@gmx.net 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
On Mon, Jun 14, 2010 at 7:33 AM, Ulas Albayrak ulas.albay...@gmail.com 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
On Mon, Jun 14, 2010 at 7:09 AM, Ulas Albayrak ulas.albay...@gmail.com 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
On Sun, Jun 13, 2010 at 9:14 AM, AI Rumman rumman...@gmail.com 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
On Mon, Jun 14, 2010 at 8:47 PM, M. Bashir Al-Noimi ad...@mbnoimi.netwrote:
On 14/06/2010 08:43 م, Dave Page wrote:
On Mon, Jun 14, 2010 at 7:22 PM, M. Bashir Al-Noimi ad...@mbnoimi.netwrote:
Hi All,
As shown in the following screenshot I couldn't install pg in Windows
because it
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
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
On 14/06/2010 11:16 م, Dave Page wrote:
On Mon, Jun 14, 2010 at 8:47 PM, M. Bashir Al-Noimi ad...@mbnoimi.net
mailto:ad...@mbnoimi.net wrote:
On 14/06/2010 08:43 م, Dave Page wrote:
On Mon, Jun 14, 2010 at 7:22 PM, M. Bashir Al-Noimi
ad...@mbnoimi.net mailto:ad...@mbnoimi.net
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
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
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
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
On Mon, Jun 14, 2010 at 11:33 PM, M. Bashir Al-Noimi ad...@mbnoimi.netwrote:
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
On Mon, Jun 14, 2010 at 4:46 PM, mark dvlh...@gmail.com 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
On Mon, Jun 14, 2010 at 5:55 PM, Phoenix Kiula phoenix.ki...@gmail.com 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
On 15/06/2010 02:26 ?, Dave Page wrote:
On Mon, Jun 14, 2010 at 11:33 PM, M. Bashir Al-Noimi
ad...@mbnoimi.net 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
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,
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
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 ad...@mbnoimi.net wrote:
Hi folks,
I tried to visit enterprisedb.com yesterday
Scott Marlowe scott.marl...@gmail.com writes:
On Mon, Jun 14, 2010 at 5:55 PM, Phoenix Kiula phoenix.ki...@gmail.com
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
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
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
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
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
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
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
On Mon, Jun 14, 2010 at 11:21 PM, M. Bashir Al-Noimi ad...@mbnoimi.net 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
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 better
79 matches
Mail list logo