Re: [GENERAL] Question about load balance
On 2012-06-11 09:35, John R Pierce wrote: On 06/10/12 11:26 PM, Condor wrote: Im not sure, just looking how to make load balance. I have a small database around 20 gb, but I expect to join another database on different scheme and Im looking for solution about load balance or some cache mechanism. Bad part is one row from db is read once in a month, in worst scenario 3-4 times in month and I think cache is not good option, but I don't have idea how will work. whats the problem you're trying to solve? so far, doesn't sound like you have anything that a decent database server couldn't handle easily. -- john r pierceN 37, W 122 santa cruz ca mid-left coast Maybe my fault that I have divided the issues into two separate e-mail, one for load balance and one bound by rules on how to bind together two bases of different schemes. As I wrote my base is small, and the server keeps a small load average, but if bind together the two databases since both must use the recording and reading 3-4 tables only, I seek advice if the server load is too much what I could do to it landed. If I run load balance with pgpool how stable will be my system, I run stream replication but I see when master send data to slave and in this time I query slave server, slave server break query. Did I will have same problems with pgpool. Basically I want to be prepared what options I have if this happens. H. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Question about load balance
On 06/11/12 12:11 AM, Condor wrote: I seek advice if the server load is too much what I could do to it landed. I recommend a faster server for this. more CPU cores, more memory, faster storage. that will take you a LONG ways, much simpler than complex and fragile database cluster schemes -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Segmentation Fault
On 06/11/2012 11:34 AM, Benson Jin wrote: Hi All, We are having a problem with our streaming replication read only node. It has crashed a few times with a couple of different reasons, mostly "segmentation fault". Any chance of examining a core dump and getting a stack trace? http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD -- Craig Ringer
Re: [GENERAL] Question about load balance
On 2012-06-11 10:23, John R Pierce wrote: On 06/11/12 12:11 AM, Condor wrote: I seek advice if the server load is too much what I could do to it landed. I recommend a faster server for this. more CPU cores, more memory, faster storage. that will take you a LONG ways, much simpler than complex and fragile database cluster schemes -- john r pierceN 37, W 122 santa cruz ca mid-left coast Yes, I now but these parameters can't be increase forever. It's can but isn't cheep. For that reason I looking some other ways. H. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] import *.backup-file (PostGIS - not mine)
Dear all I have to import and watch/edit data stored in an .backup-file. This is a backup-file, stored by an other firm. My problem is, I am new at Postgres and it is the first time I have to work with PostGIS-data. I installed pgAdminIII and tryed to import it with this program. But it will not work... Can you tell me what I have to do? best regards, Thomas -- View this message in context: http://postgresql.1045698.n5.nabble.com/import-backup-file-PostGIS-not-mine-tp5712030.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgres 9.2 beta2 one-click installer on windows
De : Craig Ringer [mailto:ring...@ringerc.id.au]
Envoyé : June-09-12 3:50 AM
(CCing Dave Page & Sachin Srivastava who work on the installer):
Short version is that the Pg installer appears to need to:
- Include the latest release of the redist because there's a security fix in it
- use /passive not /q when invoking it
- treat return 5100 as success
- swear at Microsoft for not documenting this
Continued below.
On 06/08/2012 11:55 PM, Marc Watson wrote:
Executing C:\Users\Mark
Watson\AppData\Local\Temp\postgresql_installer\vcredist_x64.exe /q
Script exit code: 5100
Is there any chance you can get the version of the currently installed MSVC++
redistributible(s) on your computer? They're listed in programs and features in
the control panel.
I originally had version 10.0.40219 installed in both 32 and 64 bit, which
gave me the error. I uninstalled these versions just to get around the 9.2
beta2 install, which installed 10.0.30319.01.
I suspect you have a newer version of the same general version (eg 2010 SP1) of
the VC++ redist installed, and rather than silently ignore the newer version
it's failing.
That was probably the case, since it's a new computer.
This appears to be a fairly common issue. It's even encountered by the Visual
C++ IDE installer its self. The short-term workaround appears to be for the Pg
installer to ignore error code 5100. Longer term, I'd like a way to tell the
VC++ redist "don't be stupid, just silently take no action if a newer version
is present."
We should also probably be using "/passive /norestart" not "/q /norestart" when
invoking the installer, since that lets the redist display useful error
messages to the user but doesn't demand interaction from them.
BTW, exit code 3100 ("succeeded but a reboot is required) should also be
handled if it isn't already.
People are using some scary workarounds, like:
http://notepad.patheticcockroach.com/1666/installing-visual-c-2010-and-windows-sdk-for-windows-7-offline-installer-and-installation-troubleshooting/
(Warning: comments are content-free zone full of me-too, plus people not
understanding what the redist does, confusing the installation of the runtime
for the us of VC++ with the "install redistributables" option that copies them
for _you_ to use in _your_ software, etc).
Also:
http://ta.speot.is/2012/04/09/visual-studio-2010-sp1-windows-sdk-7-1-install-order/
http://social.microsoft.com/Forums/en/crm/thread/db84d4c3-c58e-4ff9-997f-f4e0116bf043
http://blogs.msdn.com/b/astebner/archive/2010/10/20/10078468.aspx
BTW, IBM seems to install the redist as:
vcredist_x86.exe /q /c:"msiexec /i vcredist.msi /qn /l*v
%temp%\vcredist_x86.log"
... not sure why yet.
--
Craig Ringer
Mark Watson
Re: [GENERAL] import *.backup-file (PostGIS - not mine)
On 11 June 2012 10:42, gipsy-king1 wrote: > I have to import and watch/edit data stored in an .backup-file. This is a > backup-file, stored by an other firm. > Can you tell me what I have to do? Is that a Postgres dump? If so, is it a plain text dump, a compressed dump or a custom format dump? You can restore plain text dumps by reading them in with the psql utility. For the other dump formats you use pg_restore. If it's something else, you'll need to provide a lot more detail for us to know whether the file is at all useful to you. -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Postgres Installation Password
When attempting to download and install Postgres on my computer for work, it prompted me to create a password. Upon trying many different combinations I could not get one to work. An error message stated that the password I entered did not meet the constraints. Is there a guide to creating a password. Ryan Magruder
[GENERAL] dblink.sql not found
I have postgresql91-contrib installed in Centos 6: # yum list installed postgresql91-contrib ... Installed Packages postgresql91-contrib.x86_64 9.1.4-1PGDG.rhel6 @pgdg91 But when I try to use it I get the error: ERROR: function dblink(text, text) does not exist LINE 2: from dblink( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Also I can't find dblink.sql: # find / -name dblink.sql What am I missing? Regards, Clodoaldo
Re: [GENERAL] dblink.sql not found
On Jun 11, 2012, at 11:17 AM, Clodoaldo Neto wrote: > I have postgresql91-contrib installed in Centos 6: > > # yum list installed postgresql91-contrib > ... > Installed Packages > postgresql91-contrib.x86_64 9.1.4-1PGDG.rhel6 @pgdg91 > > But when I try to use it I get the error: > > ERROR: function dblink(text, text) does not exist > LINE 2: from dblink( > ^ > HINT: No function matches the given name and argument types. You might need > to add explicit type casts. > > Also I can't find dblink.sql: > > # find / -name dblink.sql > > What am I missing? > > Regards, Clodoaldo After installing the contrib module you have to execute following command in Database: CREATE EXTENSION dblink; Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company Blog: http://vibhork.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] dblink.sql not found
2012/6/11 Vibhor Kumar > > On Jun 11, 2012, at 11:17 AM, Clodoaldo Neto wrote: > > > I have postgresql91-contrib installed in Centos 6: > > > > # yum list installed postgresql91-contrib > > ... > > Installed Packages > > postgresql91-contrib.x86_64 9.1.4-1PGDG.rhel6 @pgdg91 > > > > But when I try to use it I get the error: > > > > ERROR: function dblink(text, text) does not exist > > LINE 2: from dblink( > > ^ > > HINT: No function matches the given name and argument types. You might > need to add explicit type casts. > > > > Also I can't find dblink.sql: > > > > # find / -name dblink.sql > > > > What am I missing? > > > > Regards, Clodoaldo > > After installing the contrib module you have to execute following command > in Database: > CREATE EXTENSION dblink; > > That worked! Thank You, Clodoaldo > Thanks & Regards, > Vibhor Kumar > EnterpriseDB Corporation > The Enterprise PostgreSQL Company > Blog: http://vibhork.blogspot.com > >
Re: [GENERAL] Postgres Installation Password
Magruder, Ryan S. wrote on 11.06.2012 16:55: When attempting to download and install Postgres on my computer for work, it prompted me to create a password. Upon trying many different combinations I could not get one to work. An error message stated that the password I entered did not meet the constraints. Is there a guide to creating a password. I assume you are using Windows (because of the mail headers) The password you have been prompted for is for the Windows user under which the Postgres service will be started. The rules for that password are defined by your Windows installation and are not (and cannot) be influenced by PostgreSQL or the installer. If you are part of a Windows domain, you need to ask your domain admin what the password rules are. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] import *.backup-file (PostGIS - not mine)
Am 11.06.2012 14:43, schrieb Alban Hertroys: > On 11 June 2012 10:42, gipsy-king1 wrote: >> I have to import and watch/edit data stored in an .backup-file. This is a >> backup-file, stored by an other firm. >> Can you tell me what I have to do? > Is that a Postgres dump? If so, is it a plain text dump, a compressed > dump or a custom format dump? try to use pg_restore with the option: -Fc > > You can restore plain text dumps by reading them in with the psql > utility. For the other dump formats you use pg_restore. > > If it's something else, you'll need to provide a lot more detail for > us to know whether the file is at all useful to you. -- Stefan Tzeggai -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Segmentation Fault
2012/6/11 Benson Jin : > Hi All, > > We are having a problem with our streaming replication read only node. It > has crashed a few times with a couple of different reasons, mostly > "segmentation fault". The latest log are listed below: > > 2012-05-30 23:56:37.385 UTC::: LOG: server process (PID 19476) was > terminated by signal 11: Segmentation fault > 2012-05-30 23:56:37.385 UTC::: LOG: terminating any other active server > processes > 2012-05-30 23:56:37.385 UTC:10.43.6.61:webmaster:panorama WARNING: > terminating connection because of crash of another server process [... cut ...] > Our setup: > 2x physical server - Dell PE R815, 64GB ECC RAM, 2 CPUs (12 cores each), > storing pgsql data on SAN backed volumes. > CentOS 5.6 > PostgreSQL 9.0.8, compiled *without* int64 datetime. > Both servers are identically configured (or at least as much as we could > ensure) Did you compiled it from scratch e.g. make clean && make && make install? []s -- Dickson S. Guedes mail/xmpp: gue...@guedesoft.net - skype: guediz http://guedesoft.net - http://www.postgresql.org.br -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Segmentation Fault
I will try produce one and submit to here. - Original Message - From: "Craig Ringer" To: "Benson Jin" Cc: pgsql-general@postgresql.org Sent: Monday, June 11, 2012 3:49:41 AM Subject: Re: [GENERAL] Segmentation Fault On 06/11/2012 11:34 AM, Benson Jin wrote: Hi All, We are having a problem with our streaming replication read only node. It has crashed a few times with a couple of different reasons, mostly "segmentation fault". Any chance of examining a core dump and getting a stack trace? http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD -- Craig Ringer
Re: [GENERAL] Question about load balance
On 06/11/12 2:11 AM, Condor wrote: Yes, I now but these parameters can't be increase forever. It's can but isn't cheep. For that reason I looking some other ways. why don't you worry about that when you get there, rather than before you even start? I've got a 2U dual xeon X5660 server w/ 48GB ram, and built in 20 x 15k raid10 that can handle like 5000 TPS-C style transactions/second, (pg_bench). these are update transactions. -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Question about load balance
On 2012-06-11 21:03, John R Pierce wrote: On 06/11/12 2:11 AM, Condor wrote: Yes, I now but these parameters can't be increase forever. It's can but isn't cheep. For that reason I looking some other ways. why don't you worry about that when you get there, rather than before you even start? May be because some times when some one start a new business does not have 20k $ for a new server and resource of the server is enough for the moment and as I planed is enough for this year. My question was how stable is pgpool, what problems I can expect, and pure curiosity what is the technique for managing large databases. CPU and memory to the second coming or are there other techniques for scattering applications on other servers. I've got a 2U dual xeon X5660 server w/ 48GB ram, and built in 20 x 15k raid10 that can handle like 5000 TPS-C style transactions/second, (pg_bench). these are update transactions. -- john r pierceN 37, W 122 santa cruz ca mid-left coast H. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] parsing the SQLERRM string
(version == 9.1) In my PL/pgSQL stored functions, I want to be able to distinguish which FK constraint caused the [foreign_key_violation] exception. . . . BEGIN delete from MY_COOL_TABLE where id = 123 ; EXCEPTION WHEN foreign_key_violation THEN CASE WHEN (SQLERRM tells me it blew up because of FK X) THEN . . . ; WHEN (SQLERRM tells me it blew up because of FK Y) THEN . . . ; WHEN (SQLERRM tells me it blew up because of FK Z) THEN . . . ; END; WHEN others THEN raise; END; . . . Is a "robust enough" parsing of SQLERRM actually the best way to do this ? If so, what assumptions can I make about the SQLERRM string ? When I set lc_messages = en_US.UTF-8' or 'fr_FR.UTF-8' or 'zh_CN.UTF-8' I get these messages: INFO: 23503: update or delete on table "TBLONE" violates foreign key constraint "FK_XXX" on table "TBLTWO" INFO: 23503: UPDATE ou DELETE sur la table < TBLONE > viole la contrainte de clé étrangère < FK_XXX > de la table < TBLTWO > 信息: 23503: 在 "TBLONE" 上的更新或删除操作违反了在 "TBLTWO" 上的外键约束 "FK_XXX" which seems to make any regex/parsing of SQLERRM real hard. Is anybody doing this ? Thanks, -dvs-
Re: [GENERAL] Question about load balance
On 06/11/12 12:17 PM, Condor wrote: May be because some times when some one start a new business does not have 20k $ for a new server and resource of the server is enough for the moment and as I planed is enough for this year. and when you start a new business, you don't lease a campus large enough for 10,000 employees, you deal with that when you need it. if your app actually ends up needing to scale to google size, plan on having to redesign it a few times. -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Question about load balance
On Tue, Jun 12, 2012 at 5:17 AM, Condor wrote: > On 2012-06-11 21:03, John R Pierce wrote: >> >> On 06/11/12 2:11 AM, Condor wrote: >>> >>> Yes, I now but these parameters can't be increase forever. It's can but >>> isn't cheep. >>> For that reason I looking some other ways. >> >> why don't you worry about that when you get there, rather than before >> you even start? > > May be because some times when some one start a new business does not have > 20k $ for > a new server and resource of the server is enough for the moment and as I > planed Postgres performance is pretty awesome even on a cheap laptop. I've done thrash testing on a basic unit that forms the backbone of our dev/test system, and also on a similar laptop that has a couple hundred dollars of SSD replacing its standard hard drive, and both of them can handle more TPS than you would think to look at them. (I don't actually have database-level TPS ratings for them, but they managed 5-10K items per second of conceptual throughput - each "item" involving quite a bit of processing.) Put it onto some real server hardware, even just $1K or so, and you'll have something that you can upgrade for as long as you need to. ChrisA -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Counting # of consecutive rows with specified value(s)?
Thank you both for the suggestions. I started playing with the window
functions, but found and copied an "islands and gaps" example that didn't
need them, and was simpler than I thought. This query seems to do the
trick:
SELECT
client_id,
count(*)
FROM
(SELECT
client_id,
attendance_code
FROM recovery_circle_attendance rca
WHERE attended_on >
(SELECT max(attended_on)
FROM recovery_circle_attendance
WHERE client_id=rca.client_id AND attendance_code != 'ABSENT')
) foo
GROUP BY client_id;
It's a fairly small dataset, so at least right now I'm not too worried
about performance, but am curious if this is a reasonably well-optimized
way to get this info, or if there are any glaring issues or room for
improvement in this regard?
Cheers,
Ken
On Thu, Jun 7, 2012 at 12:35 PM, François Beausoleil
wrote:
>
> Le 2012-06-06 à 22:20, Ken Tanzer a écrit :
>
>
> I can currently test whether someone has at least a specified number of
> consecutive absences with the query below, but it would be better to get
> the actual number.
>
> As a second question, what about getting the number of consecutive records
> for a set of values? (e.g., attendance_code IN ('ATTENDED','EXCUSED')
>
> Any ideas or suggestions? Thanks.
>
>
> This is similar to the islands and gaps problem. Search for that on
> StackOverflow and you'll get it.
>
> Bye!
> François
>
--
AGENCY Software
A data system that puts you in control
*http://agency-software.org/*
ken.tan...@agency-software.org
(253) 245-3801
Re: [GENERAL] Extension table data
Along with Chris, the need for having tables defined in the extension is about keeping control of the table structure so the extension functions are guaranteed to work as intended and to make upgrading versions easier. As an example, the fact that I can specifically name constraints makes it easier to write an extension upgrade script if that constraint needs to change because I know exactly what I called it. Trying to support extensions and requiring that we write long, explicit instructions for creating and maintaining the associated tables is just asking for trouble. Especially when we can have the control we need to avoid these issues. Honestly, the big issue I have right now is that it is dumping data with the schema-only option and only dumping that data if you do a complete database dump. That is making it very difficult to manage extensions even using them as they're documented now. I think its time to recognize the extension system is more widely usable than it was originally intended. And that's a good thing! We just need to try to find ways to make the existing tools work in a more predictable manner now. -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. 443.325.1357 x251 On Sat, Jun 9, 2012 at 9:56 AM, Chris Travers wrote: > On Sat, Jun 9, 2012 at 5:33 AM, Tom Lane wrote: >> Keith Fiske writes: >>> Just found something else rather disturbing. If you try to exclude the >>> schema that the extension tables are in, their data is still output. >> >> This is a common misconception: extensions do not live within schemas. >> (An extension might own a schema, not the other way around.) So a >> dump with a -n switch is never going to select an extension. >> >> By and large, if the current behavior bothers you, ISTM it probably >> means you are using these tables in a way other than what the concept of >> an extension configuration table was meant for: namely, to hold >> configuration data that would be referenced by the functions in that >> extension, but would not normally be considered part of the user's data. >> There has been some talk of trying to cater for a more general notion of >> tables created by extensions, but we do not have a design or even a >> clear idea of a set of requirements for that. Perhaps it would be good >> if you explained what is your use-case --- why are you concerned about >> being able to manage these tables as if they were regular data? >> > Here's a use case I have been thinking a lot about lately. I am not > sure that extensions is the right vehicle for it, but it may be a good > starting point. > > LedgerSMB is moving towards a more modular structure and LedgerSMB 1.5 > will probably require PostgreSQL 9.1 or higher (owing to the writable > CTE's). I have been looking at how the extension system can be used > to simplify our maintenance and it helps quite a bit. However, one > key aspect that would be really nice would be managing schema changes > along with changing versions of an extension. For example, one might > have a fixed asset module, and that module might have a series of > stored procedures. We would have some tables that store configuration > data regarding the module. For example we might have a table that > stores info on stored procedures that track depreciation methods. The > use of tables for configuration data in the current approach fits this > nicely. > > However we might have other tables which store data, things like which > fixed assets get depreciated in which ways, and the like. These may > need to have columns added from time to time, or have other alter > table operations performed. It would be nice to be able to manage > these schema changes and upgrading the extension in the same > framework. > > I am wondering if some sort of "database modules" framework might be > helpful with modules possibly having extensions, but also having data > tables. > > Best Wishes, > Chris Travers -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] ctid ranges
On Fri, 2012-06-08 at 22:27 +0100, Thomas Munro wrote: > This is slow, handled with a seq scan (as are various rephrasing with > <, <=, etc): > > SELECT ... FROM ... WHERE ctid BETWEEN ... AND ...; > > Is there a way to retrieve the rows in a physical range quickly? Interesting idea. However, as far as I know, there is no such support. Regards, Jeff Davis -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Run external SQL file via Perl dbh
On 10/06/12 08:29, David Williams wrote:
Hi There,
I'd like to be able to run the contents of an external SQL file from Perl.
Something akin to:
$dbh->do( '\i /home/david/run_me.sql' );
However this fails, and I assume that is because the \i is a client command. Is
there a way to run the contents of an external SQL from a Per database handle?
How about something like
use File::Slurp;
use Try::Tiny;
try {
$dbh->being_work;
$dbh->do($_) for split(/;/, read_file('run_me.sql'))
$dbh->commit;
}
catch {
say "Failed SQL: $_";
$dbh->rollback;
};
That will break if you have any semi-colons inside quoted strings, but
you could improve the splitting to cope with that..
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Run external SQL file via Perl dbh
Toby --
A small point:
<...>
>How about something like
>
>use File::Slurp;
>use Try::Tiny;
>
>try {
> $dbh->being_work;
$dbh-begin_work;
<...>
Clarification for any who might be unfamiliar with the perl tools.
Greg Williamson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Run external SQL file via Perl dbh
On Mon, Jun 11, 2012 at 7:37 PM, Greg Williamson wrote: > Toby -- > > A small point: > > <...> > As a brief note, the semicolon splitting issue was why we went with invoking psql via system(). We found that was vastly simpler than trying to handle all corner cases ourselves. Best Wishes, Chris Travers -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Segmentation Fault
Hi All, A silly question how do I get install external symbols for postgresql, if compiled it myself previously? Do I recompile it with --enable-debug option? Cheers, Benson - Original Message - From: "Craig Ringer" To: "Benson Jin" Cc: pgsql-general@postgresql.org Sent: Monday, June 11, 2012 3:49:41 AM Subject: Re: [GENERAL] Segmentation Fault On 06/11/2012 11:34 AM, Benson Jin wrote: Hi All, We are having a problem with our streaming replication read only node. It has crashed a few times with a couple of different reasons, mostly "segmentation fault". Any chance of examining a core dump and getting a stack trace? http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD -- Craig Ringer
Re: [GENERAL] Question about load balance
On 2012-06-11 22:47, John R Pierce wrote: On 06/11/12 12:17 PM, Condor wrote: May be because some times when some one start a new business does not have 20k $ for a new server and resource of the server is enough for the moment and as I planed is enough for this year. and when you start a new business, you don't lease a campus large enough for 10,000 employees, you deal with that when you need it. if your app actually ends up needing to scale to google size, plan on having to redesign it a few times. -- john r pierceN 37, W 122 santa cruz ca mid-left coast --- cut --- My question was how stable is pgpool, what problems I can expect, and pure curiosity what is the technique for managing large databases. CPU and memory to the second coming or are there other techniques for scattering applications on other servers. --- cut --- I think I'm trying to learn information what is the technique for managing large databases not to philosophize what was my server. H. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Question about load balance
> My question was how stable is pgpool, what problems I can > expect, and pure curiosity what is the technique for managing large > databases. > CPU and memory to the second coming or are there other techniques for > scattering > applications on other servers. > > > --- cut --- > > I think I'm trying to learn information what is the technique for > managing large databases > not to philosophize what was my server. You'd better to subscribe pgpool-gene...@pgpool.net list (http://www.pgpool.net/mediawiki/index.php/Mailing_lists) and post this kind of question. There are many people who are serious about pgpool in the list. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Question about load balance
Hi, > I think I'm trying to learn information what is the technique for managing > large databases > not to philosophize what was my server. In this case it starts to get very specific about what you are trying to accomplish. Transactional databases offer a lot guarantees, which makes it hard to "just add another machine to the cluster", this isn't a webserver ;) - Clemens -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
