.1.
Did you try a reload?
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi:
I have questions regarding replication db tech for PG. Is this the right
forumn?
Thanks for any direction !
rastructure guys responsible so they check double-check for any
problems.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Dec 15, 2009 at 8:26 PM, Richard Broersma
wrote:
> On Tue, Dec 15, 2009 at 12:15 PM, Dave Page wrote:
>
>>> After selecting retry, the install process completes successfully.
>>
>> That's not necessarily a problem, it usually means something was still
>
:31 PM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] replication dbs
Gauthier, Dave wrote:
I have questions regarding replication db tech for PG. Is this the right
forumn?
Sure. You can find some slightly rough documentation for help get you started
at http
Hi Everyone:
Tomorrow, I will need to present to a group of managers (who know nothing about
DBs) why I chose to use PG over MySQL in a project, MySQL being the more
popular DB choice with other engineers, and managers fearing things that are
"different" (risk). I have a few hard tecnical reas
nd thanks to all who have contributed. Really!
-Original Message-
From: Massa, Harald Armin [mailto:c...@ghum.de]
Sent: Thursday, December 17, 2009 3:14 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Justifying a PG over MySQL approach to a project
Dave,
-
From: Erik Jones [mailto:ejo...@engineyard.com]
Sent: Thursday, December 17, 2009 4:42 AM
To: Craig Ringer
Cc: Gauthier, Dave; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Justifying a PG over MySQL approach to a project
On Dec 16, 2009, at 10:30 PM, Craig Ringer wrote:
> - If you don&#
How difficult is it to switch the master's hat from one DB instance to another?
Let's say the master in a master-slave scenario goes down but the slave is
fine. Can I designate the slave as being the new master, use it for
read/write, and then just call the broken master the new slave once it
One concern I have about these trigger based replication systems is that I fear
it may ping the slave for each and every DML statement separately in time and
in a transaction. My slave will literally be 1400 miles away and all
replication communications will be over the net. If I have a transa
Can you define your own commands in PG. E.g., if users from other DBs use
"describe foo" to get the metadata for foo, is there a way I can create a
command "describe" to = "\d" ?
Thanks in Advance
Hi:
Are metadata creation strings, in sql form, stored anywhere in the metadata
tables? So if I...
create table foo (x int);
I would like to pull that same string from somewhere.
Thanks in Advance
dmin supports collation and ctype on all platforms
when creating databases. If the options are disabled, it's because the
OP is running a server older than 8.4.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
kowski [mailto:plk.zu...@gmail.com]
Sent: Saturday, December 19, 2009 7:00 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] defining yuor own commands in PG ?
2009/12/18 Gauthier, Dave
mailto:dave.gauth...@intel.com>>
Can you define your own commands in PG.
In
pop.jaring.my]
Sent: Sunday, December 20, 2009 10:05 AM
To: Greg Smith; Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Justifying a PG over MySQL approach to a project
At 05:44 AM 12/17/2009, Greg Smith wrote:
>You've probably already found
>
e Free &
Open Source world, please send in your proposal by the end of
tomorrow!
On Thu, Dec 3, 2009 at 10:48 AM, Dave Page wrote:
> FOSDEM (http://www.fosdem.org/2010/) is a major Free and Open Source
> event held annually in Brussels, Belgium, and attended by around 4000
> people. A
I was wondering...
In head-to-head comparisons, do DBs get stree tested, not only in terms of
performance, but in terms of corruptions, down time, recovery time, lost data,
etc... .?
I've heard it said that MySQL is superior to MySQL in this regard. But if this
were stated in an article fro
Is there a way to modify or delete an element of an array with knowledge only
of the element's value? Maybe an array index finder would help?
For example
create table foo (name,text, arr text[]);
insert into foo (name,arr) values ('joe',ARRAY['a','b','c']);
update foo set arr[indexfinder('b')
I'm not sure this is the right place to enquire...
I'm trying to connect to a postgres datanbase with Java.
import java.sql.*;
public static void main(String[] args) {
// TODO code application logic here
try{
System.out.println("Starting...");
Class.fo
inaries.zip" to
> "postgresql-8.5alpha3-windows-binaries.zip" in my browser URL, things are
> working.
Sorry about that - the link should be fixed now.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
there is an old-fashioned way of doing things that
> went out with Mac OS X 10.4, and I'm glad to say it looks like the latest
> postgres doesn't install like this..
Look in /Library/LaunchDaemons/
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-gener
On Mon, Jan 4, 2010 at 1:42 PM, Chris Withers wrote:
> Dave Page wrote:
>>
>> On Mon, Jan 4, 2010 at 1:38 PM, Chris Withers
>> wrote:
>>>
>>> Naoko Reeves wrote:
>>>>
>>>> Try check this directory: Library: StartupItems: postgr
On Mon, Jan 4, 2010 at 2:32 PM, Chris Withers wrote:
> Dave Page wrote:
>>
>> Iirc, you have to change:
>>
>> RunAtLoad
>>
>>
>> to
>>
>> RunAtLoad
>>
>
> I feel slightly stupid asking this, but thi
I actually tackled a problem very much like this in the distant past with a
different DB. I think one of the practical questions you have to ask is
whether or not you really need all that detailed data, or would storing
summarized data serve.
If (for example) the components are fabricated on w
thedb=# create table foo (col1 text, constraint chk check (col1 in
('a','b','c',null)));
CREATE TABLE
thedb=# insert into foo (col1) values ('xxx');
INSERT 0 1
H... I would have thought that this would have violated the constraint
because 'xxx' is not null and nit one of the allowed values.
Hertroys [mailto:dal...@solfertje.student.utwente.nl]
Sent: Thursday, January 07, 2010 5:49 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] interesting check constraint behavior
On 7 Jan 2010, at 24:12, Gauthier, Dave wrote:
> thedb=# create table foo (col1 text, con
right-clicking them and
selecting Properties, and then choosing the new tablespace.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Anyone else want to join us for dinner? Please shout even if you
haven't firmed up your travel plans yet, so I have a rough idea of
numbers.
Thanks.
On Fri, Dec 11, 2009 at 6:59 PM, Dave Page wrote:
> As in previous years, we're looking at organising a dinner prior to
> the FOSD
:33 AM, Dave Page wrote:
> Anyone else want to join us for dinner? Please shout even if you
> haven't firmed up your travel plans yet, so I have a rough idea of
> numbers.
>
> Thanks.
>
> On Fri, Dec 11, 2009 at 6:59 PM, Dave Page wrote:
>> As in previous year
Sounds great fun!
However, I presume I'm on the wrong Continent! ;)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Jan 14, 2010 at 1:14 PM, Dave Coventry wrote:
> Sounds great fun!
>
> However, I presume I'm on the wrong Continent! ;)
>
I have no idea. I'm on the wrong landmass though, so there will be at
least one person arriving by air :-)
--
Dave Page
EnterpriseDB UK: http:
Yes, I'm in South Africa, which might make it problematic!
2010/1/14 Dave Page :
> On Thu, Jan 14, 2010 at 1:14 PM, Dave Coventry wrote:
>> Sounds great fun!
>>
>> However, I presume I'm on the wrong Continent! ;)
>>
>
> I have no idea. I'm o
Hello !
I have a long list of records I want to insert into a table in such a way as I
can trap and report any/all constraint violations before rolling back (or
opting to commit). Unfortunately, after I hit the first constraint violation,
it aborts the transaction, and then reports "ERROR: cur
keep going. Nothing from the
entire stream is committed until/unless they're all clean.
Thanks
-Original Message-
From: Joshua D. Drake [mailto:j...@commandprompt.com]
Sent: Thursday, January 14, 2010 6:35 PM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL]
Is there a way to set a column to be read only?
I have a table with several columns with values that are determined by
triggers. I want users to be able to view, but never edit them.
Thanks
osed
to a trigger silently overriding whatever they may have thought they changed.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Saturday, January 16, 2010 9:00 PM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Read only column ?
"Gauthier,
2010 9:12 PM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Read only column ?
"Gauthier, Dave" writes:
>> .. although, if you have triggers forcibly setting the columns, it
>> hardly matters what the users try to put into them, no?
> U..
nuary 16, 2010 9:18 PM
To: Tom Lane
Cc: Gauthier, Dave; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Read only column ?
Tom Lane wrote:
> Well, you could have the triggers throw errors instead of being silent
> about it.
>
>
otoh, do you really want trigger code ch
Is there a clever way to replace a single element in an array with another
value?
E.g.
x = array['a','b','c','d'];
I want to replace 'b' with 'x'.
Thanks for any suggestions!
Hi:
I'm dealing with a hierarchical design where changes in one record can and
should cause changes in other records lower inthe hierarchy. I'm trying to use
update triggers to do this. And recursion would be a real nice way to do this.
What I need to know is if, in the "after" update trigge
From: Craig Ringer [mailto:cr...@postnewspapers.com.au]
Sent: Sunday, January 24, 2010 11:34 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Recursion in triggers?
Gauthier, Dave wrote:
> What I need to know is if, in the "after" update trigger I make the
&g
On Fri, Jan 29, 2010 at 1:29 PM, Enrico Pirozzi wrote:
> Hi,
> I would like to find an odbc driver for mac os x,
> where I can find it?
>
> Thanks to all
If you're running the one-click PG installer, you can install the ODBC
driver using StackBuilder.
--
Dave Page
E
gt;>>
>>>
>>> While looking into a failed check_postgres check, I found a problem
>>> with the canonical versions page here:
>>>
>>> http://www.postgresql.org/versions.rss
>>>
>>> It only goes back to 8.0, but as far as I know, 7.4 is not
2010/1/29 Devrim GÜNDÜZ :
> On Fri, 2010-01-29 at 15:08 +0000, Dave Page wrote:
>> > Perhaps because you only display five releases in the "Latest
>> Releases"
>> > part of the front page? which means 8.0 to 8.4.
>>
>> Yes. iirc, that was the reas
Hi:
PG V8.3.4 running on Linux.
I have a DB with a bunch of users attached as gleaned from "ps auxww | grep
postgres". How can I learn more about these users, who they are if coming in
via the net, what kind of resources they are using, what they are running, how
I can kill them?
I'm open to
analyze? Does the empirical data the optimizer use develop good queries get
updated with/after a restore?
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Scott Marlowe
Sent: Thursday, February 04, 2010 1:32 PM
To: Wang
create table foo (name text, company text, job text);
insert into foo (name,company,job) values ('joe','ge','engineer');
insert into foo (name) values ('sue');
What I want to do is map joe's company and job over to the sue record, ending
up with
'sue' 'ge' 'engineer'
Is there a quick/clever
Outstanding !
Thanks Alban.
-Original Message-
From: Alban Hertroys [mailto:dal...@solfertje.student.utwente.nl]
Sent: Wednesday, February 10, 2010 11:46 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] need clean way to copy col vals from one rec to
On Thu, Feb 11, 2010 at 11:00 AM, wrote:
> Hi,
>
> Please why is it that we must register at EnterpriseDB and register each
> Windows installation of postgreSQL these days?
There is no requirement to register to use or download PostgreSQL.
--
Dave Page
Enterpris
Hi:
create table foo (lst text[]);
insert into foo (lst) values (array['jack','fred','jen','sue']);
I want to find all records where any element of lst like 'j%'.
This does not work...
select * from foo where 'j%' like any(lst);
Intuitively, you'd think
select * from foo where any(lst) li
y related to the fact that the platform API on both 32 and
64 bit platforms is known as win32 (with a more complete name of
'win32 for 64 bit Windows' on 64 bit).
My understanding is that this is because the naming originally came
from the transition from 16 to 32 bit which involved a
s
> there anything I should be aware of?
Its certainly not one of the many scenarios we test, but there
shouldn't be any problems that I can think of. We do test and support
both Vista and Windows 7, and there's no special installation steps
that differ on either, and the software is the sam
ve columns).
We run this test automation quite a few platforms and have never
encountered this problem on any of them:
- All flavors of windows NT from win2k onwards, including an older win7 box
- linux: x86 + x86_64
- macos: x86_64
- solaris: sparc + x86 + x86_64
- Dave
--
Sent via pgsql-
Hi again,
I'm going to answer my own question. I think there is a race where two
database servers are being setup on the same port at the same time and
two different tests end up trying to create the same DB on the same
server at the same time.
Let me know if you think I'm wrong
with this? There are suspicions the
> server is quite the CPU hog.
Noone has ever measured or noticed any real cost that I'm aware of.
Obviously there will be some though, so if you're not using the
debugger and you are concerned just remove plugin_debugger from the
shared_libraries_pr
supported platform for
PostgreSQL. I have no idea if it will work or not.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
PG East Conference: http://www.enterprisedb.com/community/nav-pg-east-2010.do
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
re rate than the one-click installer (which
based on the ratio of downloads to bug reports, is down to something
like 45000:1 at this point, or a 99.997% success rate).
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
loyalty as it'll
be much harder for them to change to a different, SQL-based
database. That'll be pretty cool."
You may also notice that without SQL, the project name is somewhat
misleading. To address that, the project name will be changed to
'PostgreQUEL' with the
ome
exploration.
Sachin told you how to install in a nutshell, but I guess you missed
that so here are the detail walkthrough instructions:
http://www.enterprisedb.com/learning/pginst_guide.do
I don't think that's bad for *free* support.
--
Dave Page
EnterpriseDB UK: http://www.enterpr
On Thu, Apr 1, 2010 at 9:30 AM, Thom Brown wrote:
> I prefer to dump all my data in a big text file and grep it for the
> information I need.
There's no need to start showing off and get all technical y'know.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent v
>> I do not like the installer's suggestion to put the data directory into
>> c:\Program Files either, I think this should default to %APPDATA%
The reasons why we do that have been discussed here before - check the archives.
As a point of reference - wanna guess where Microsoft S
your office to try to help
(again, for free), who you refused to talk to.
Unless you are prepared to help us understand exactly what is unique
about your systems so we can figure out what is going wrong, then we
cannot help you.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
er place to put it.
>
> IIRC, that was modeled on where Microsofts own SQL Server put it's
> data files by default. Does anybody know if that has changed recently?
It hasn't. I checked 2008 this morning.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via
On Thu, Apr 1, 2010 at 12:15 PM, Peter Geoghegan
wrote:
> I think that the EDB one click installer for windows is a great piece
> of software, and I'm very grateful to Dave and the EDB people for
> maintaining it, as well as the stack builder that it comes with.
Thank you Peter -
ut isn't it
> worth investigating in order to fix the installer?
The old installer used entirely different technology, which is not
easily comparable. It was also never tested on Windows 7.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (p
On Thu, Apr 1, 2010 at 12:40 PM, Massa, Harald Armin wrote:
> Dave,
>>
>> >
>> > IIRC, that was modeled on where Microsofts own SQL Server put it's
>> > data files by default. Does anybody know if that has changed recently?
>>
>> It hasn&#x
he-Worlds-Fastest-Database.aspx
Yeah, I read that earlier in my daily lunchtime jaunt over to the
Daily WTF. Alex clearly spent more time on his text than I did!
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
ctly in the face
of a system secured according to the Federal Desktop Core
Configuration (FDCC) mandate
(http://www.microsoft.com/industry/government/federal/fdccdeployment.mspx),
but frankly Windows offers a million and one ways to tighten/screw up
security.
--
Dave Page
EnterpriseDB UK: http://www.en
k, you HAVE to change the default dir, I went and installed to
> c:\postgresql\8.4 and its alive and running.
>
if that were the case, there is no way the installer would have got
through even basic sanity testing, never mind the barrage of tests
every release does go through successfull
s fine on all our test systems,
including 64 bit versions of XP, Vista, 7, 2003 and 2008. I will be
chatting with my colleagues later to try to figure out what the issue
may be, though a quick Google indicates there are a number of possible
causes for this issue. We'll also be looking for possible
"StackBuilder" it's probably the MSI installer.
The MSI installer has StackBuilder. Judging by the service name, I'd
guess this was the MSI.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
;> So there was no actual 8.3 base release of PPAS?
>
> No, and I assume the version numbers will all match for future releases.
That's the plan.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company
--
Sent via pgsql-general mailing list (pgsql-g
Here's a real long shot, but what the heck...
I have a user that's using a system that gives him a single MySQL DB handle to
work with. He must get all his data through this handle. He wants some of my
PG based data. Not only can't he open a new DB handle to my PG DB, but he
cannot even run
ay, October 20, 2011 3:33 PM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Reading PG data from MySQL stored procedure
On Thu, Oct 20, 2011 at 2:22 PM, Gauthier, Dave wrote:
> Here's a real long shot, but what the heck...
>
>
>
> I have a user that&#
, 2011 10:23 PM
To: Gauthier, Dave
Cc: Merlin Moncure; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Reading PG data from MySQL stored procedure
On 10/21/2011 03:56 AM, Gauthier, Dave wrote:
> The software system they are being forced to use gives them the ability to
> send queries to a
Can you be more specific as to what you are looking for ? I presume
there is something between you and the connection so when you turn
autocommit on it doesn't work ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Thu, Oct 20, 2011 at 4:34 PM, S. Balch
Hi:
I need to be able to select all records with a col value that matches any of a
list of regexp. Sort of like...
select a,b,c from foo where d ~ ('^xyz','blah','shrug$');
Does anyone know the right syntax for this?
Thanks!
v8.3.4 on linux.
Does "reindex table foo" require no other users accessing the foo table?
Trying to understand why this seems to be stalled when I attempt this on a live
DB (if runs fine/fast on a copy of the DB that no one uses).
Should I run this inside a transaction?
Thanks in Advance !
Hi:
PG v8.3.4 on linux. Server is at one corporate site, half the DB users are at
that site, the other half are at a different site 2 time zones away. Users
from both sites access the DB through the same, generic postgres user accout
that has select/insert/update/delete only. And almost all
I think you need exclusive access to the table in order to add columns (I'll
stand/sit corrected if the more experienced responders say different). I've
found that you have to either wait for them to get off or kill them first (as
in pg_ctl kill ABRT).
From: pgsql-general-ow...@postgresql.or
Hi:
PG v4.8.3 on Linux
I'm using "selcet procpid,current_query from pg_stat_activity" to monitor
activity during times when "top" is showing many PG procs with very high cpu
usage numbers (all cores at or above 90%). Some of these are procs that map to
PG connections with current_query = .
W
, Gauthier, Dave wrote:
>
> I'm using "selcet procpid,current_query from pg_stat_activity" to
> monitor activity during times when "top" is showing many PG procs with
> very high cpu usage numbers (all cores at or above 90%). Some of
> these are p
11 2:58 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] connections and cpu consumption
On 11/09/11 11:35 AM, Gauthier, Dave wrote:
> A... so if the script that has the connection open would only terminate
> the transaction, then vacuum wouldn't get behind?
>
> I act
pg_ctl --help lists the various SIGNALNAME options to use with "pg_ctk kill"...
Allowed signal names for kill:
HUP INT QUIT ABRT TERM USR1 USR2
I can't find a description of what each does. I'd like to abort just the
procpid I enter, but using ABRT has a tendancy to kill lots of other stuff t
Hi:
How can I search on a csv list of values using "like" where each value is to be
appended with a wildcarded string?
Example:
list = 'jo,mo,do,fo'
I want to pull all names from a table with name like.. 'jol%' or 'mol%'
or'dol%' or 'sol%'
would match "jolly, molly, moleman,dollface, solarboy
The example was a general case. It won't be jo and mo and fo. In fact, the
values will be stored in a csv perl scalar.
If you know perl...
$str = "jo,mo,do,fo";
Using DBI, I need to "prepare" a query that will accept a string like the one
above.
So...
select name,age,weight from people_ta
12:37 PM, Gauthier, Dave wrote:
> bi_dev=# select name from test where name ~ '^(' || replace('jo,mo,do,fo',
> ',', '|') || ')l';
> ERROR: argument of WHERE must be type boolean, not type text
ah, needs () around the right side of the ~
Hi:
I have a pg_dump pf a v8.3.4 DB that I would like to bring into a v9.0.1 PG
instance. What is the best way to do this? Note, the dump file is too big to
fit into an editor, but I could sed it if need be.
Thanks.
: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_dump of a v8.3.4 -> v9.0.1
On 11/23/2011 08:08 AM, Gauthier, Dave wrote:
> Hi:
>
> I have a pg_dump pf a v8.3.4 DB that I would like to bring into a v9.0.1
> PG instance. What is the best way to do this? Note, t
You set the trigger to fire off whenever ed_expore.bv is inserted or updated.
Then the trigger updates ed_explore.bv, which fires the update trigger again,
etc... . Infinite loop. No?
Maybe you just want to use a before trigger to set that value before the
insert, then you wouldn't need the
Hi:
SImple/quick (hopefully)
thedb=# \dT+
List of data types
Schema | Name| Internal name | Size | Elements | Description
+---+---+---+--+-
public | one_string_rec| one_string_rec
mum columns in an index: 32
Maximum size of a TOAST chunk:1996
Date/time type storage: 64-bit integers
Float4 argument passing: by value
Float8 argument passing: by value
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credati
Answering my own question
hot_standby = off by default..
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Dec 5, 2011 at 6:43 AM, Dave Cramer wrote:
> This is the second hot_standby server that I have setup for this
> particular master server. The log
v8.3.4 on linux
Is there a way to set the query used in a "for rec in (query) loop -> end loop"
be a variable? Example
if (foo = 'whatever')
then
sqlstmt := "select x,y,z ...";
else
sqlstmt := "select a,b,c ...";
end if ;
for therec in
sqlstmt
loop
...
end loop;
Thanks in Advance f
Hi:
How can I make "pager off" the default when running psql ?
v8.3.4 and v9.0.1 on linux.
Like a charm. Thanks!
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Wednesday, December 07, 2011 9:57 AM
To: pgsql-general@postgresql.org
Cc: Gauthier, Dave
Subject: Re: [GENERAL] making "\pset pager off" the default
On Wednesday, December 07,
Dong,
How are you copying the wal logs over to the secondary ? Since this is
loosely coupled I am wondering how the master would be effected by
load.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Tue, Dec 13, 2011 at 12:42 AM, Dong Han wrote:
> Dear all,
>
&g
Dong,
Once the wal_copy command completes the primary is free to handle the
wal logs as it sees fit. Is it possible that rsync is getting behind ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Dec 12, 2011 at 11:28 PM, Dong Han wrote:
> Dave,
>
> The
Why am I getting this?
xdb=# alter table templates add constraint manager_uid_is_invalid check
((constraint_checker('manager',manager,null,null)) = 'OK') DEFERRABLE ;
ERROR: syntax error at or near "DEFERRABLE"
LINE 1: ...int_checker('manager',manager,null,null)) = 'OK') DEFERRABLE...
v8.3.4 on
PG V9.0.1 on Linux
I want to temporarily prevent users from connecting to a DB, let the existing
connections finish, , re-enable connections.
What's the best way to do that?
Thanks in Advance
701 - 800 of 1235 matches
Mail list logo
