of the process, is this an indicator that the backend
process was trying to shutdown?
I'm assuming that if it's trying to 'close ports' then it would be
shuting down the process.
Are there multiple scenarios where this routine would be called?
--
Until later, Geoffrey
Tom Lane wrote:
Geoffrey <[EMAIL PROTECTED]> writes:
Question is, when I see:
#17 0x08151bc5 in ClosePostmasterPorts ()
in the stack trace of the process, is this an indicator that the backend
process was trying to shutdown?
No; that's a function that's executed immediately
amewar-starting question?
As a nudist, I think I have to answer, "About every 9 weeks, it would
seem".
Jeese! You could have warned us to shield our eyes!
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Li
ding such items at http://www.cafepress.com/
Here's the tinyurl to a search for postgresql, which found a few items
as well as some semi-related:
http://tinyurl.com/27onuq
I found all kinds of clothing as well as coffee cups, license plate
frames and clocks.
--
Until later, Geoffrey
Tho
changes that would require the least amount of additional work?
That is, would it be more efficient to move to 8.2.? and then implement
our Slony replication, or would there be less effort in implementing the
Slony solution and then upgrading to 8.2.? ?
--
Until later, Geoffrey
Those who
acceptable.
Thanks for the response.
Geoffrey wrote:
We plan to upgrade from our current 7.4.17 Postgresql to 8.2.? in the
near future. We also plan to implement a replication solution, most
likely Slony.
We know that the upgrade to 8.2.? will require some code changes.
Question is,
Has anyone taken a stab at adding plperl syntax highlighting for vi?
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---(end of broadcast
Tom Lane wrote:
Geoffrey Myers <[EMAIL PROTECTED]> writes:
The output from the gdb batch process may be found here:
http://www.serioustechnology.com/gdbbatch.txt
gdb isn't telling you the whole truth, evidently --- how'd control get
from line 781 to 912 with nothing in betwe
Tom Lane wrote:
Geoffrey Myers <[EMAIL PROTECTED]> writes:
The output from the gdb batch process may be found here:
http://www.serioustechnology.com/gdbbatch.txt
gdb isn't telling you the whole truth, evidently --- how'd control get
from line 781 to 912 with nothing in betwe
Martijn van Oosterhout wrote:
On Tue, Aug 07, 2007 at 07:46:45AM -0400, Geoffrey wrote:
I don't know all the idiosyncrasies of how this works, so bear with me
on this. The developer at the vendor indicated that he's narrowed down
the problem to a set of wrapper routines in their c
We are looking for a reporting tool that will enable users to generate
their own reports. Something like Crystal Reports.
Anyone using something like this with Postgresql?
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve
Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Geoffrey wrote:
We are looking for a reporting tool that will enable users to generate
their own reports. Something like Crystal Reports.
Anyone using something like this with Postgresql?
Why not Crystal Reports?
My
Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John DeSoi wrote:
On Aug 22, 2007, at 7:21 PM, Geoffrey wrote:
We are looking for an open source reporting tool that will enable
users to generate their own reports. Something like Crystal Reports. ;)
I was looking at a
Thanks for the various responses, I'll check them out and post my
research results and our decision.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Fra
soft' creation. I really
don't understand the purpose, because by the time you consider
'recalling' the email message, it's already sitting in 1000s of inboxes...
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safet
Ow Mun Heng wrote:
On Tue, 2007-09-18 at 06:52 -0400, Geoffrey wrote:
[EMAIL PROTECTED] wrote:
Robert Wickert would like to recall the message, "August Monthly
techdata split file printers for France and Denmark ".
In my experience, attempting to 'recall' an email me
Andrus wrote:
Use
www.fyireporting.com
Open source, uses excellent PostgreSQL npgsql drivers.
Use standard RDL format
I guess I should have noted that we will need to run this on Linux clients.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---(end of broadcast)---
TIP 6: explain analyze is your friend
Rodrigo De León wrote:
On 10/4/07, Geoffrey <[EMAIL PROTECTED]> wrote:
Anyone have a recommendation for a good sql tutorial? Looking for a
book, but online would be useful as well.
This is for a financial user who will need to have an understanding of
sql in order to generate reports
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/04/07 10:28, Geoffrey wrote:
Anyone have a recommendation for a good sql tutorial? Looking for a
book, but online would be useful as well.
This is for a financial user who will need to have an understanding of
sql in
[EMAIL PROTECTED] wrote:
Scott Marlowe wrote:
On 10/4/07, Geoffrey <[EMAIL PROTECTED]> wrote:
Anyone have a recommendation for a good sql tutorial? Looking for a
book, but online would be useful as well.
I'd recommend The Art of SQL and Joel Celko's books. None are onlin
Rodrigo De León wrote:
On 10/4/07, Geoffrey <[EMAIL PROTECTED]> wrote:
I know how to use google, I'm looking for recommendations. What an ass.
If you found my reply to be lacking, you can say so without being rude...
Stating the obvious google search to me is just as rude. I
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/04/07 11:06, Geoffrey wrote:
Ron Johnson wrote:
On 10/04/07 10:28, Geoffrey wrote:
Anyone have a recommendation for a good sql tutorial? Looking for a
book, but online would be useful as well.
This is for a financial
Scott Marlowe wrote:
On 10/4/07, Geoffrey <[EMAIL PROTECTED]> wrote:
Anyone have a recommendation for a good sql tutorial? Looking for a
book, but online would be useful as well.
I'd recommend The Art of SQL and Joel Celko's books. None are online
that I know of, but they&#
Rodrigo De León wrote:
On 10/4/07, Geoffrey <[EMAIL PROTECTED]> wrote:
Stating the obvious google search to me is just as rude. I was looking
for recommendations based on others' experiences.
That was not my intention, so I'm sorry if you felt that way.
My apologies then.
$119.
abebooks.com shows one used %96, three used at $549.05. :)
Thanks the pointer though.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
Andrus wrote:
I guess I should have noted that we will need to run this on Linux
clients.
Geoffrey,
You can run FYIReporting engine in Linux using MONO ( www.go-mono.com )
Thanks, we're looking for something that will run natively on Linux.
--
Until later, Geoffrey
Those who would gi
Bill Moran wrote:
Geoffrey <[EMAIL PROTECTED]> wrote:
Andrus wrote:
I guess I should have noted that we will need to run this on Linux
clients.
Geoffrey,
You can run FYIReporting engine in Linux using MONO ( www.go-mono.com )
Thanks, we're looking for something that will run
Ned Lilly wrote:
On 10/14/2007 6:41 PM Geoffrey wrote:
Bill Moran wrote:
Geoffrey <[EMAIL PROTECTED]> wrote:
Andrus wrote:
I guess I should have noted that we will need to run this on Linux
clients.
Geoffrey,
You can run FYIReporting engine in Linux using MONO (
www.go-mono.com )
reports which a gui that requires no
more then sql knowledge.
On 10/15/07, Geoffrey <[EMAIL PROTECTED]> wrote:
Ned Lilly wrote:
On 10/14/2007 6:41 PM Geoffrey wrote:
Bill Moran wrote:
Geoffrey <[EMAIL PROTECTED]> wrote:
Andrus wrote:
I guess I should have noted that we will need to
can't help you with
that scenario as I don't have any experience with it and postgresql.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---(end
suspect Slony is not a solution for your effort. See:
http://slony.info/documentation/slonyintro.html#INTRODUCTION
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
--
3.3 or newer to
be able to build and use Slony-I.
It says the same thing in the Slony 1.2.12 docs rpm.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---
html email conversations.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---(end of broadcast)---
TIP 3: Have you checked our ext
imply is not the way it's done on this list. Get use to
it. Now who's doing the 4 year old crying??
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
--
Joshua D. Drake wrote:
Geoffrey wrote:
Collin Kidder wrote:
I have to suffer through dealing with people like the two of you
quoted above. You can deal with people who'd like to top post.
Anything else is just being a spoiled baby who can't deal with minor
issues. If all the en
OOXML debacle?
The list continues, but I suspect you get my point.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---(end of broadcast)-
Joshua D. Drake wrote:
Geoffrey wrote:
Johan van Zyl wrote:
Please elaborate! (Many a true word spoken in jest)
"That is until I can convince my new employer to realise the dark side
of Microsoft SQL Server."
It's the product of an evil company? Let's see:
1. they are
g (on the fly)
index creation)
This is correct. You want an empty replication database. When you
start replication slony will bring the master and slave into sync.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neithe
ql? I just want to use 64bit if it as stable as 32bit.
I'm curious as to why you would run iptables on a database server. My
expectation would be that your database machine would be behind a
dedicated firewall.
--
Until later, Geoffrey
Those who would give up essential Liberty, to pu
me | Object | Description
+--++--
public | carr | table | Carrier File
(1 row)
mwv=# \dd avlds;
Object descriptions
Schema | Name | Object | Description
+--++-
(0 rows)
Question is, why does the avlds table not have an entry in the Object
descriptions?
It seems that I recall there is a way to display the actual select
statement that is executed when you execute the \d command.
Anyone?
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin
very* long time.
Are you speaking from personal experience, or just of the lack of
maintenance?
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---(end of
ion of the
data was complete. That is, once the replication server 'caught up'
with the production server.
I posted to the slony list about this issue, but didn't get any bites.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary
with slony seems to be related to a table that
has just such a key, so we are trying to figure out if this is causing
the problem.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
Peter Childs wrote:
On 20/02/2008, Geoffrey <[EMAIL PROTECTED]> wrote:
So, we are trying to track down some problems we're having with an
implementation of slony on our database. I've posted to the slony list
about this issue, but I wanted to get a more generic response from th
ich, but I'm
afraid 7.4 is too old).
How might we find out which release it was fixed in? Back patching
7.4.19 with the fix might be easier then trying to move up to the fixed
version.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Saf
, thus, it's our understanding that using
tgenabled is not going to be a solution.
Making our triggers smarter doesn't get us all the way there.
Suggestions?
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither L
+20 if need be, I'd go with - (dash) over _ (underbar)
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
role to control how it acts
in a particular transaction.
The issue at hand (I work with the OP), is that our current application
disables all triggers quite often. Enter Slony, we want to replicate.
So, what we need to do is, disable ALL triggers EXCEPT slony triggers.
--
Until later, Geoff
? Any ideas?
Version:
PostgreSQL 7.4.19 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.6
20060404 (Red Hat 3.4.6-9)
Me thinks you forgot to mention that you are working on implementing
this on Postgresql 8.3.1.
--
Until later, Geoffrey
Those who would give up essential Libert
J Ottery wrote:
Thanks Craig for making me look like an idiot. I feel bad now.
You don't look like an idiot, you look like someone who has just learned
something. If we don't learn from our mistakes, then we are idiots... ;)
--
Until later, Geoffrey
Those who would give up
your
presentation...
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
I'm still running 8.1
What about the:
8.1 -> slony -> 8.3
switch users to 8.3 databases
solution.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
--
Sent via pgsql-gen
Joshua D. Drake wrote:
On Fri, 18 Apr 2008 13:54:52 -0400
Geoffrey <[EMAIL PROTECTED]> wrote:
What about the:
8.1 -> slony -> 8.3
switch users to 8.3 databases
solution.
Is it? What is your transactional velocity? How long will the initial
sync transaction have to run? You
Joshua D. Drake wrote:
On Fri, 18 Apr 2008 14:30:18 -0400
Geoffrey <[EMAIL PROTECTED]> wrote:
I don't know that slony is the answer. It was more of a question
then an answer. We are hoping to use that solution to migrate from
7.4.19 to 8.3.1. The primary reason is to reduce downt
Alvaro Herrera wrote:
Geoffrey wrote:
Joshua D. Drake wrote:
On Fri, 18 Apr 2008 14:30:18 -0400
Geoffrey <[EMAIL PROTECTED]> wrote:
I don't know that slony is the answer. It was more of a question
then an answer. We are hoping to use that solution to migrate from
7.4.19 to
he electrons are traveling pretty close to the speed of
light. ;)
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
Alvaro Herrera wrote:
Geoffrey wrote:
I'm really not altogether sure what you mean by transaction velocity.
I'm pretty sure the electrons are traveling pretty close to the speed of
light. ;)
Actually, electrons themselves flow rather slowly -- millimeters per
second according to
ree to shoot holes in
this solution if it is not viable.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
on this server in the past 6 weeks. The
problem seems to have started last friday, when reports started to go
missing.
What has changed prior to Friday?
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
Marcelo Giovane wrote:
Please, remove me from the list!
Generally, when you find your way into a location, you are expected to
find your way out...
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety
I was poised to say the same as you until I
realised this. :-)
They have come through on every other post, however.
I don't really want to drag this out into a discussion, but the
instructions are provided to you when you subscribe.
--
Until later, Geoffrey
Those who would give up e
I'm trying to build a customized pg_standby.c and I can not locate
pg_usleep(). Can anyone point me to the source file that contains this
library? (or even better,the associated Red Hat rpm?)
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temp
Richard Huxton wrote:
Geoffrey wrote:
I'm trying to build a customized pg_standby.c and I can not locate
pg_usleep(). Can anyone point me to the source file that contains
this library? (or even better,the associated Red Hat rpm?)
port/pgsleep.c
If you're a perl guy might be worth
Richard Huxton wrote:
Geoffrey wrote:
Richard Huxton wrote:
Geoffrey wrote:
I'm trying to build a customized pg_standby.c and I can not locate
pg_usleep(). Can anyone point me to the source file that contains
this library? (or even better,the associated Red Hat rpm?)
port/pgsleep.
he archive
server, but I don't see a *.history file.
What am I missing?
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
--
Sent via pgsql-general mailing list (pgsql-general
Joshua D. Drake wrote:
On Tue, 2009-06-02 at 15:21 -0400, Geoffrey wrote:
My problem is, I never see a *.history file, thus my script sits in a
loop looking for it. I see the WAL files showing up on the archive
server, but I don't see a *.history file.
What am I missing?
pg_stand
Geoffrey wrote:
Joshua D. Drake wrote:
On Tue, 2009-06-02 at 15:21 -0400, Geoffrey wrote:
My problem is, I never see a *.history file, thus my script sits in a
loop looking for it. I see the WAL files showing up on the archive
server, but I don't see a *.history file.
What am I mi
Joshua D. Drake wrote:
On Tue, 2009-06-02 at 15:21 -0400, Geoffrey wrote:
My problem is, I never see a *.history file, thus my script sits in a
loop looking for it. I see the WAL files showing up on the archive
server, but I don't see a *.history file.
What am I missing?
pg_stand
Joshua D. Drake wrote:
On Tue, 2009-06-02 at 15:21 -0400, Geoffrey wrote:
My problem is, I never see a *.history file, thus my script sits in a
loop looking for it. I see the WAL files showing up on the archive
server, but I don't see a *.history file.
What am I missing?
pg_stand
Joshua D. Drake wrote:
On Tue, 2009-06-02 at 19:44 -0400, Geoffrey wrote:
pg_standby it self isn't a solution for warm standby. It is a component
thereof. Also don't use SCP. Use rsync. Take a look at walmgr or
PITRTools it will make your life easier.
I still don't und
shell). I'm certainly looking at rsync rather then scp, which really
makes more sense.
Greg Smith wrote:
On Tue, 2 Jun 2009, Geoffrey wrote:
The problem with my current process is as noted, my script keeps
looking for the *.history file, but never sees it.
From the restore_command sect
Erik Jones wrote:
On Jun 3, 2009, at 5:13 AM, Geoffrey wrote:
Thank you Greg for taking the time to explain this as throughly as you
have. I have found a logic problem in my code. I still don't know if
we will use pg_standby as the wrapper code in PITRTools is python and
we are
Joshua D. Drake wrote:
On Wed, 2009-06-03 at 14:43 -0400, Geoffrey wrote:
pg_standby is in no way dependent on PITRTools. PITRTools is, however,
dependent on pg_standby. Put another way: you do not need to use
PITRTools to use pg_standby. In fact, you also don't need any perl or
Greg Smith wrote:
On Wed, 3 Jun 2009, Geoffrey wrote:
My assumption was that since pg_standby does not have the scp/rsync
functionality, I would have to either modify it, change the way we do
things, or 'reinvent' a little different wheel.
There are three things to setu
Joshua D. Drake wrote:
On Wed, 2009-06-03 at 15:07 -0400, Geoffrey wrote:
You are still going to need to either:
A. Reinvent the wheel, by scripting it all yourself
B. Use solutions that are already used by others such as walmgr or
pitrtools
My assumption was that since pg_standby does not
Greg Smith wrote:
On Thu, 4 Jun 2009, Geoffrey wrote:
For now, I'm still looking at the other tools as well as attempting to
verify that my current solution doesn't miss any 'little issues.'
The main thing you want to test out are that it acts sanely when the
netwo
ql-general
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
cation, thus the network
reliability is less.
Thanks for any insights.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
--
Sent via pgsql-general mailing list (pgsql-general@postgre
I'm trying the following:
ship_date between '04/30/2010' AND '04/30/2010' + 14
But this returns:
ERROR: invalid input syntax for integer: "04/30/2010"
Can I use between with dates?
--
Until later, Geoffrey
"I predict future happiness for America
Geoffrey wrote:
I'm trying the following:
ship_date between '04/30/2010' AND '04/30/2010' + 14
But this returns:
ERROR: invalid input syntax for integer: "04/30/2010"
Can I use between with dates?
Got it:
ship_date between '04/30/2010' a
Tom Lane wrote:
Geoffrey writes:
ship_date between '04/30/2010' AND '04/30/2010' + 14
ERROR: invalid input syntax for integer: "04/30/2010"
Can I use between with dates?
The problem with that is the parser has no reason to treat the strings
as dates,
Do temp tables need to be explicitly dropped, or do the go away when the
process that created them leaves?
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of
ever asked for that. There must be some tool
that will dump an HTML tree as a single text file.
Or maybe convert the PDF file to text.
On Linux:
/usr/bin/pdftotext
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labo
Does postgresql have functions to calculate the distance between two
sets of longitude and latitude.
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
n not find this piece of info in the docs?
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson
--
Sent via pgsql-general mailing
Gerd Koenig wrote:
Hi Geoffrey,
you do not need to connect to your database directly, just connect to pgpool
itself.
e.g.: your database runs on port 5434, pgpool runs on port 5432
=>
* pgpool has to be configured in that way that it connects to the database on
port 5434
* you/your ap
Gerd Koenig wrote:
Hi Geoffrey,
you do not need to connect to your database directly, just connect to pgpool
itself.
e.g.: your database runs on port 5434, pgpool runs on port 5432
=>
* pgpool has to be configured in that way that it connects to the database on
port 5434
What parameter
Geoffrey wrote:
Gerd Koenig wrote:
Hi Geoffrey,
you do not need to connect to your database directly, just connect to
pgpool itself.
e.g.: your database runs on port 5434, pgpool runs on port 5432
=>
* pgpool has to be configured in that way that it connects to the
database on port 5
rectory1 = '/data/pgsql/mwv'
In my pgpool.conf file and I've restarted the pgpool processes. I can
connect to the first entry as follows:
psql -p master
But if I attempt to connect to the second postmaster as follows:
psql -p mwv
I can not connect. What am I missing?
--
Unti
Guillaume Lelarge wrote:
Le 21/06/2010 15:52, Geoffrey a écrit :
So I've got the following:
port =
.
.
backend_hostname0 = 'localhost'
backend_port0 = 5434
backend_weight0 = 1
backend_data_directory0 = '/data/pgsql/master'
backend_hostname1 = 'l
tions
are used, what happens to the 21st connection attempt? Is it rejected
or put into a queue to wait for the next available connection?
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
th
John R Pierce wrote:
On 06/21/10 5:37 AM, Geoffrey wrote:
So I've got 13 different databases on 13 different postmasters, now
does pgpool know which databases I'm trying to connect to?
you would need 13 different connection pools.
Can this be done?
--
Until later, Geoffrey
Scott Marlowe wrote:
On Mon, Jun 21, 2010 at 1:45 PM, Geoffrey wrote:
John R Pierce wrote:
On 06/21/10 5:37 AM, Geoffrey wrote:
So I've got 13 different databases on 13 different postmasters, now does
pgpool know which databases I'm trying to connect to?
you would need 13
Scott Marlowe wrote:
On Mon, Jun 21, 2010 at 2:42 PM, Geoffrey wrote:
Scott Marlowe wrote:
On Mon, Jun 21, 2010 at 1:45 PM, Geoffrey
wrote:
John R Pierce wrote:
On 06/21/10 5:37 AM, Geoffrey wrote:
So I've got 13 different databases on 13 different postmasters, now
does
pgpool know
priority users have a
larger connection pool.
Is there a problem with using connection pooling and traditional
connections to connect to the same database?
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the p
ostgres".
This user must also own the server process.
.
.
Why is it trying to change directory to /root??? Running as the
postgres user.
Any assistance would be appreciated.
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from
Tom Lane wrote:
Geoffrey writes:
I wrote a script that creates a new database from an existing backup.
Works great on my machine. Another user tries to use it and sees the
following output from initdb:
could not change directory to "/root"
The files belonging to this database s
stgres??
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
1 - 100 of 312 matches
Mail list logo
