My use case:
I have a table which I expect to reach a size of more than 10M rows.
This table will have a column "partner_uuid" which will have a maximum
envisioned cardinality of 10.
I want different users of my web application to see different subsets
of that table. I am using row-level security
On Wed, Nov 30, 2016 at 6:45 PM, Merlin Moncure wrote:
> On Wed, Nov 30, 2016 at 10:42 AM, Tom Lane wrote:
>> George writes:
>>> explain select * from wg3ppbm_transaction where partner_uuid in (
>>> select p.uuid
>>> from wg3ppbm
On Wed, Nov 30, 2016 at 8:44 PM, Tom Lane wrote:
> Merlin Moncure writes:
>> On Wed, Nov 30, 2016 at 11:05 AM, George wrote:
>>> So there is definitely something wrong here. This situation makes many
>>> row-level security use cases cumbersome since you need to hav
On Wed, Nov 30, 2016 at 10:08 PM, George wrote:
> On Wed, Nov 30, 2016 at 8:44 PM, Tom Lane wrote:
>> Merlin Moncure writes:
>>> On Wed, Nov 30, 2016 at 11:05 AM, George wrote:
>>>> So there is definitely something wrong here. This situation makes many
>
On Thu, Dec 1, 2016 at 6:58 PM, Tom Lane wrote:
> George writes:
>> explain analyze select *
>> from wg3ppbm_transaction where partner_uuid in (
>> select p.uuid
>> from wg3ppbm_userpartner up
>> join wg3ppbm_partner p on p.id
of data in circular fashion. Is there a
clever way of selecting partition by date when there are 15 of them?
Or is it waterfall time (add/delete tables every month)?
Thanks,
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:
- Original Message -
From: Bret Stern
I use odbc in a windows environment.
No complaints, can do inserts, select, updates, joins, execute stored
procedures
with little fuss...more than fast enough for my purposes.
There are some issues with 32/64 bit odbc depending on your relat
7;murder' ? Such wasted opportunities :p
???
Dish - Dishes
Fish - School
Bow - Bows
Crow - Murder
Goose - Geese
Moose - Moose
House - Houses
Mouse - Mice
and so on...
Cheers,
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
htt
ss across servers.
FYI: articles about sharding using bigint keys.
http://instagram-engineering.tumblr.com/post/10853187575/sharding-ids-at-instagram
http://rob.conery.io/2014/05/29/a-better-id-generator-for-postgresql/
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to your lawyers rather than
ask here.
At least in the US, the "normal course of business" applies to archive
data as well as to live data, so you may be able to limit how long you
need to keep the journals.
Hope this ... doesn't further confuse.
George
--
Sent via pgsql-general
Hi Kanakaraju,
This is a long shot but in case "case" matters, on all my computer the
variable is "ComSpec".
And I assume you added it as a System variable...
Cheers,
George
On 13/10/2016 6:24 AM, Karre, Kanakaraju (US - Hyderabad) wrote:
I have been trying to install
95 rows=1 loops=1)
Index Cond: ((timeslot <= '2016-10-20
21:40:00+00'::timestamp with time zone) AND (pollgrpid = 497582) AND (dsnum
= 0))
Total runtime: 2604.818 ms
(35 rows)
My problem is that if I run this against a newly created pollgrpid/dsnum
pair, there is no data in the earlier tables and my guess is that the query
switches to an seqence scan because I cannot get the query to finish ( my
last attempt did not complete after waiting 10 minutes ).
Any suggestions would be appreciated
George Woodring
iGLASS Networks
www.iglass.net
to have a separate log for the second instance in the new
cluster?
Thanks,
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 30/11/2016 9:16 PM, John R Pierce wrote:
On 11/30/2016 3:01 PM, George Weaver wrote:
I have set up 2 instances of PostgreSQL 9.6 on the same Windows
server. I noticed when I ran initdb for the second instance that it
did not create a pg_log folder in the new cluster, and that all
logging
I've never used it but what about:
https://developer.sugarcrm.com/2012/08/03/like-postgresql-and-want-to-use-it-with-sugarcrm-check-out-a-new-community-project/
Cheers,
George
On 13/12/2016 2:24 PM, Joshua D. Drake wrote:
On 12/13/2016 12:19 PM, John R Pierce wrote:
On 12/13/2016 10:
t connection to an
Internet facing database, but I am dead set against allowing direct
connection from any browser hosted code because - regardless of any
"shrouding" that might be done - browser code is completely insecure,
accessible to anyone who can right-click on the page.
George
--
Se
"create"
call before using the table.
Second, it allows temporary tables to be _per_user_ ("global") in
addition to per connection ("local"). Global temp tables are shared
by simultaneous connections from the same user - once created they
persist until the last connection
t;fuzzy" deletion. There are
a number of timestamps in your data ... is it not possible to delete
deterministically based on one of them?
Hope this helps,
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
available
on the same system [there is also a less friendly way to do it via EML
files exported from Outlook where Outlook is not on the same system].
Thunderbird directly supports net news, so you don't have to get news
mixed with your mail (unless you want to).
Hope this helps,
George
--
On Sun, 29 Nov 2015 05:04:42 -0500, "Steve Petrie, P.Eng."
wrote:
>"George Neuner" wrote in message
>news:kaed5btl92qr4v8ndevlgtv0f28qaae...@4ax.com...
>
>> My vote for an email client would be Thunderbird. It runs on XP or
>> higher and you can impo
eletions until (some kind of) vacuum is run.
Autovacuum doesn't shrink the table space on disk, it merely compacts
the table's live data so that any free space is at the end.
If you want to tightly control the growth of the table space, you need
to run autovacuum _more_ often, not l
nsaction that
can "see" it is still running.
For more:
https://devcenter.heroku.com/articles/postgresql-concurrency
https://momjian.us/main/writings/pgsql/mvcc.pdf
Actually lots of great stuff in the presentation section on Bruce
Momjian's site: https://momjian.us
George
--
Sent via pgsq
but superficially I think it achieves what you want.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
es it ... it's too big a security risk for a general purpose
system. It's intended to support embedded systems where the set of
programs is known.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postg
re is a known algorithm for satisfying the
page requests, but the set of free pages includes both code and data
and depends on the history of system activity. There's no guarantee
to get anything useful.
I'm not sure any of this really answers your question.
George
--
Sent via pgsq
ion open
for the entire script instead of making 2 connections, but I would like to
try to find out what is going wrong.
Any suggestions would be appreciated.
Thanks,
George
iGLASS Networks
www.iglass.net
I went and look and we have the ssl_renegotiation_limit set to the default,
which the documentation says is 0.
Thanks,
George
iGLASS Networks
www.iglass.net
On Thu, Dec 31, 2015 at 3:16 PM, Adrian Klaver
wrote:
> On 12/31/2015 11:29 AM, George Woodring wrote:
>
>> OS: CentOS 6.6
S Networks
www.iglass.net
On Thu, Dec 31, 2015 at 2:29 PM, George Woodring wrote:
> OS: CentOS 6.6
> Postgres Version: 9.3.10
>
> I have a script that is worked for years that does the following
>
> - Connect to postgres and get a list of URLs to poll for status
> - close connectio
h images stored
already compressed the transmitted size is minimized, and you will
only ever decompress (on the client) data in the critical path to the
display.
Hope this helps,
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
OT64 encoded, etc.
Characters in Java are 16-bit values. If you convert the BLOB into a
printable string [or your debugger does to view it], that string will
be twice as long as the binary.
Hope this helps,
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
he differences between the operating systems, I'm not any
kind of expert at tuning Postgresql.
Hope this helps,
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, 12 Feb 2016 14:43:55 -0800, John R Pierce
wrote:
>On 2/12/2016 2:28 PM, George Neuner wrote:
>> In Linux the distinction between a "workstation" and a "server" is
>> largely a matter of system configuration. Windows "desktop" and
>> &q
2bits (xp, Win7).
>> > >
>> > > If change to:
>> > > prep->bindLengths[i] = 8;
>> > >
>> > > Postgresql error goes, but the wrong value is inserted.
Yes. The length needs to be 8 for a "long long" value, and the value
itself needs to be converted correctly for TCP network byte order.
I don't work directly with libpg, so I can't say if anything else is
wrong here.
Hope this helps,
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
me is repeatable wrt some epoch.
And if there are concurrent requests, their completion order is not
guaranteed.
It is also true in Oracle, and in every general purpose DBMS that I
know of. So what exactly do you "test" using a fixed date/time?
George
--
Sent via pgsql-general maili
ables where desired.
IMO, the only real added value of a dedicated column store system is
to developers: the automagic table fragmentation and the ability to
query virtual tables rather than specify table fragments individually.
Convenient, but not necessary.
YMMV,
George
--
Sent via pgsql-g
nces performance mainly by not fetching and not
caching unused data. And standard practices like controlling the
physical locations of tables help both row and column store systems.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
arbirtrary programs as services so they can
run at startup and in the background, but programs that weren't
written explicitly to BE services don't obey the service manager and
their diplayed status usually is bogus (provided by the launcher).
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ny web facing system I design always involves mediation via
middleware. IME it is the copying/conversion of data to/from the
HTTP interface that ultimately limits performance, so where to put the
database code largely is a judgement call.
YMMV,
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e DLLs and look for any
that say "fixed base" under "DLL characteristics". If you find more
than one that have the same "image base" address, then you've got a
problem.
If you don't find anything, then I would guess 9.1 is just too old.
Ho
On 5/5/2016 1:17 PM, Moreno Andreo wrote:
Il 05/05/2016 18:40, George Neuner ha scritto:
Otherwise: if Postgresql is loading any non-standard extensions, I
would try to check those DLLs. If you have a recent Visual Studio
handy, run "link /dump /headers " on the DLLs and look for an
(or Unix) you'd set up a forwarding record in iptables that
redirects a second port to Postgresql.
http://www.cyberciti.biz/faq/linux-port-redirection-with-iptables/
I don't know offhand a way to do that on Windows, but I presume that
it is possible.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
:= NULL;
>> begin
txt := coalesce( txt1, '' )
|| coalesce( txt2, 'txt2 was null' )
|| coalesce( txt3, '') ;
>> raise notice '%', txt;
>> end$$ language plpgsql;
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e explanation, see
https://en.wikipedia.org/wiki/Two_Generals'_Problem
>Thanks in advance,
>Zoltán Böszörményi
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I can't really
>figure out how the "embedded" is actually "embedded".
Firebird is available as a DLL on Windows and Linux.
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/ufb-cs-embedded.html
George
--
Sent via pgsql-general maili
On 5/29/2007 10:19 AM, Ed L. wrote:
> On Wednesday 23 May 2007 1:04 pm, George Pavlov wrote:
> FWIW, I've also been seeing this sort of query log corruption for
> as long as I can remember, 7.1 through 8.2, HPUX (parisc, ia64),
> Linux on intel, amd...
Do you have any tricks for
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> "George Pavlov" <[EMAIL PROTECTED]> writes:
> > On 5/29/2007 10:19 AM, Ed L. wrote:
> >> FWIW, I've also been seeing this sort of query log corruption for
> >> as long as I can remember, 7.1 through
From: Tom Lane [mailto:[EMAIL PROTECTED]
> "George Pavlov" <[EMAIL PROTECTED]> writes:
> > ... Also redirect_stderr = on.
>
> Hm. Well, that's the bit that ought to get you into the PIPE_BUF
> exception. There's been some speculation that a change
> From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
>
> In those rare cases wouldn't it make more sense to just set
> enable_seqscan to off; run query; set enable_seqscan to on;
1. these cases are not that rare (to me);
2. setting enable_seqscan (in JDBC, say) from the application makes the
whole
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> "George Pavlov" <[EMAIL PROTECTED]> writes:
> > I am curious what could make the PA query to ignore the
> index. What are
> > the specific stats that are being used to make this decision?
>
> you don
> From: Tom Lane
> "George Pavlov" <[EMAIL PROTECTED]> writes:
> >> From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
> >> In those rare cases wouldn't it make more sense to just set
> >> enable_seqscan to off; run query; set enable_seqscan
cesses are writing
at the same time uninterrupted.
Anything else I can do to diagnose?
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of George Pavlov
> Sent: Saturday, June 02, 2007 11:33 AM
> To: Tom Lane
> Cc: Ed L.; pgsql-general@
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> What are the total lengths of the log entries in which you see the
> failure? (The "length" here includes all the lines belonging to a
> single logical entry, eg, ERROR, DETAIL, HINT.)
It is very hard to tease these apart because now that I look at it
> With DROP CASCADE, he can get rid of
> everything within
> the schema at a blow, so this is really pretty close to the same
> functionality.
but beware of cross-schema dependencies! e.g., a DROP SCHEMA CASCADE of
schema X containg a table that has a column defined using a domain from
schema Y w
7; upon a successful insert and 'failure' if
insert fails.
You can find out whether the insert was successful or not using the tools
here:
http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
Regards,
George
What's the plan for releasing the next 8.1? There hasn't been a release
since April and there have been fixes. (I personally am particularly
interested in "implement chunking protocol for writes to the syslogger
pipe" because without it over 2/3 of attempts at query analysis f
as everyone has pointed out it does not seem like the best table design
and querying for these fields as normal course of business does not seem
that great, but if you wanted to audit tables like these once in a while
you could easily do it using your favorite scripting language or SQL
itself. here
i am trying to create a temp table inside a plpgsql function (i just
need a temporary place to hold data, but it is too complex for any other
data structure). unfortunately if i call the function again within the
same session the temp table still exists and the function fails. if i
drop the temp ta
select
to_char(ts, 'MM/DD/') as "day",
str,
proc,
sum(case when z!=0 then 1 end) as good,
sum(case when z =0 then 1 end) as bad
from foobar
where str != 9
group by 1,2,3
order by 1
;
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf
> From: David Fetter [mailto:[EMAIL PROTECTED]
> On Tue, Sep 11, 2007 at 08:55:53AM -0700, George Pavlov wrote:
> > sum(case when z!=0 then 1 end) as good,
>
> This case statement returns true when z factorial is zero, so I'd
> recommend the SQL standard <>
> I am trying to create an expression which
> - always yield true if the incomming array is NULL
> - yields true if a given value is in the array, otherwise yields false
>
> I thought this should work:
> Select 'target'=ANY(COALESCE('{indata1, indata2}','{target}'))
>
> but I get an ERROR: op AN
redirect_stderr | on
George
---(end of broadcast)---
TIP 6: explain analyze is your friend
('foo');
INSERT 0 1
development=# CREATE TABLE foo1 (foo text REFERENCES foo);
CREATE TABLE
development=# INSERT INTO foo1 VALUES ('FOO');
ERROR: insert or update on table "foo1" violates foreign key constraint
"foo1_foo_fkey"
DETAIL: Key (foo)=(FOO) is not present in table "foo".
Thanks,
George
From: Peter Geoghegan
Subject: Re: [GENERAL] Case Insensitive Foreign Key Constraint
I would probably just have a check constraint that prevented the
relevant PK field from being lower case in the first place. I had to
do that recently, but my approach reflected the business rules.
This is wh
autovacuum_freeze_max_age = 2
autovacuum_vacuum_cost_delay = 20ms
autovacuum_vacuum_cost_limit = -1
Any suggestions would be appreciated.
Thanks,
George Woodring
--
iGLASS Networks
www.iglass.net
<>
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscr
I was able to upgrade the machine on Wednesday to 9.0.3 and we saw the spike
on Thursday, right on the 8 day schedule. I will keep my eye out next
Friday to see if it happens again. This will have the whole period on the
new version.
Thanks
George
On Wed, Mar 16, 2011 at 7:12 PM, Aleksey
We are still seeing the spike in vacuums every 8 days, even after upgrading
to 9.0.3. Any suggestions on how to spread them out?
Thanks,
George Woodring
>
> On Wed, Mar 16, 2011 at 7:12 PM, Aleksey Tsalolikhin <
> atsaloli.t...@gmail.com> wrote:
>
> Do you see thi
ble
in the device manager.]
Most USB disks and Flash devices do support write caching. If you are
willing to live dangerously, you can get better write performance.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
Hi Craig,
On Fri, 12 Sep 2014 11:33:55 +0800, Craig Ringer
wrote:
>On 09/11/2014 03:16 PM, George Neuner wrote:
>>
>> If the driver permits it and you [or your users] can be trusted to
>> perform a safe unmount via the OS *before* disconnecting the device,
>> then y
7;t
require accounts, so I am uncertain how I suddenly could be denied
reading privilege ... even to post it only requires that you be
subscribed to the particular list. I can't think of any reason my
address would be black-listed ... unless, of course, all of comcast.net
has been black
looping through the rows in the buffer table and
checking to see when the Model No changes).
I'm wondering if there is a more elegant way to do this using straight sql
from Excel?
Thanks for your help/suggestions!
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
> If the user's session is still valid then a row will be returned (Redis
> automatically destroys the key on expiry).
>
>
> --
> -- to reset the expiry timeout for the user
> --
> UPDATE rsessions SET expiry = 40 WHERE sessid = $1;
>
>
>
> Leon
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
George R. C. Silva
SIGMA Consultoria
http://www.consultoriasigma.com.br/
Sorry for the late reply...life interefered...
From: "Jim Nasby"
On 1/15/15 9:43 AM, George Weaver wrote:
Hi List,
I need to import data from a large Excel spreadsheet into a PostgreSQL
table. I have a program that uses ODBC to connect to Excel and extract
data using SQL que
Hi Adrian,
From: "Adrian Klaver"
Subject: Re: [GENERAL] "Ungroup" data for import into PostgreSQL
On 01/15/2015 04:56 PM, Jim Nasby wrote:
On 1/15/15 9:43 AM, George Weaver wrote:
Hi List,
I need to import data from a large Excel spreadsheet into a PostgreSQL
table. I
Hi List,
Trying to install PostgresSQL 9.4.1 on Window XP Pro Service Pack 3.
Installation is aborted with the following error:
Unknown error while running C:\Documents and Settings\George Weaver\Local
Settings\Temp\postgresql_installer_dc46cfee2c\getlocales.exe
bitrock_installer.log
Hi Adrian,
From: "Adrian Klaver"
Subject: Re: [GENERAL] "Ungroup" data for import into PostgreSQL
On 01/15/2015 04:56 PM, Jim Nasby wrote:
On 1/15/15 9:43 AM, George Weaver wrote:
Hi List,
I need to import data from a large Excel spreadsheet into a PostgreSQL
table. I
Hi Adrian,
From: "Adrian Klaver"
Subject: Re: [GENERAL] "Ungroup" data for import into PostgreSQL
On 01/15/2015 04:56 PM, Jim Nasby wrote:
On 1/15/15 9:43 AM, George Weaver wrote:
Hi List,
I need to import data from a large Excel spreadsheet into a PostgreSQL
table. I
Sorry for the late reply...life interefered...
From: Jim Nasby
On 1/15/15 9:43 AM, George Weaver wrote:
Hi List,
I need to import data from a large Excel spreadsheet into a PostgreSQL
table. I have a program that uses ODBC to connect to Excel and extract
data using SQL queries. The
message-id/canfyu97_wyaxjge_kegr62mqwovy0exjbqec9cl8stlkakw...@mail.gmail.com
In fact, the Enterprise DB site states: The 9.x installers are supported on
and Windows XP and above.
All the best,
George
- Original Message -
From: Bald, Glenn
To: gwea...@shaw.ca ; pgsql-general@postgresql.org
Se
some indication not to try...
9.3 seems to work quite nicely on XP.
George
In an effort to actually be helpful ...
Do you _need_ 9.4? Can you go back (possibly to 9.2) to a version that was
in use closer to when XP was still supported? I don't know if that will
help, but it seems like a reason
3am PST when I pull it
out. If I save it to timestamp without timezone, I get 6am now where as
before I would get 3am.
Any suggestions would be appreciated
George Woodring
iGLASS Networks
www.iglass.net
timezone y.
George Woodring
iGLASS Networks
www.iglass.net
On Mon, Feb 23, 2015 at 9:16 AM, Dave Cramer wrote:
> Well you could always just put it back to whatever you want when you open
> the connection ie "set timezone "
>
>
>
> Dave Cramer
>
> dav
27;US/Pacific" and I see it
change, when I do another RESET timezone it goes back to US/Eastern.
Thanks,
George Woodring
iGLASS Networks
www.iglass.net
On Mon, Feb 23, 2015 at 10:49 AM, Tom Lane wrote:
> George Woodring writes:
> > Yes, that is where we think we are heading, th
-- In your original post you mentioned that access to the databases is
through a Web server.
-- Is there just one Web server with one time zone?
We have 2 web servers that are clustered together. They are both set to
Eastern since that is the timezone they are located in.
iGLASS Networks
www.
r the viewer, without the web code having to know
the timezone.
George Woodring
iGLASS Networks
www.iglass.net
Good day.
We trying to implement IPv6 address space management with postgres
support, but I found few strange problems.
One of them - problems with math. In IPv4 we can be sure, that
inet'0.0.0.1' + N allows to get any address you want, because N < 2^64,
and IPv4 is just 32-bit size.
But I
e queries,
or fix the problem in the code?
Thanks,
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Until you can get PostgreSQL to install correctly there's no point in
messing around with a broken installation.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
:\ProgramData\PostgreSQL\9.2\data
5. Having completed the above, try using the installer from
http://www.enterprisedb.com/postgresql-924-installers-win64?ls=Crossover&type=Crossover
to re-install PostgreSQL?
If you did all of the above, what happened?
George
--
Sent via p
registry entry to point to the default data location on
the C: drive
2. Using pg_ctl to point postgresql to D:\..\9.2\data or
D:\..\9.2\data_old
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
s that - at least for SQLServer - a
simple case involving a string column is probably insufficient, and
complex scenarios are required to produce significant differences.
]
I'll get around to doing some testing soon. For now, I am just asking
if anyone has ever run into something like this
Hi David,
On Sat, 4 Mar 2017 02:32:48 +1300, David Rowley
wrote:
>On 3 March 2017 at 18:26, George Neuner wrote:
>> I know most people here don't pay much - or any - attention to
>> SQLServer, however there was an interesting article recently regarding
>> significa
m will see the new version.
I don't know what issues you may face in upgrading from 8.2 - I have
never tried leaping so many [major] versions at once.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql
onment control messages sent to their main
window.
pg_ctl is a command-line program that can run as a service. But since
it creates no window, when run as an application it cannot receive any
environment messages.
If you run postgresql as an application, you need to stop the cluster
manual
On Mon, 20 Mar 2017 12:05:01 +0100, Karsten Hilbert
wrote:
>On Mon, Mar 20, 2017 at 06:48:36AM -0400, George Neuner wrote:
>
>> Windows informs all processes that it is shutting down (or entering
>> sleep, or waking up, etc.), but the notifications take different forms
>&
discussion when some of its
participants are on Google.
That said ...
I also dislike having my email full of list posts. I prefer to follow
groups and lists through NNTP (net news) whenever possible. Many
(all?) of the Postgresql lists are available via Gmane[*]. For
historical (hysterical?)
he period of locking is
relatively short [wrt to the unlocked period and for some respective
definitions of "relatively"].
YMMV,
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
inux at sharing library
code (DLLs) between/among processes. Postgresql starts several admin
processes to begin with, and then starts a new process for each client
connection.
>Thanks & regards,
>Ertan Küçüko?lu
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
reads can
be hard to follow even with a decent news reader.
[Postgresql lists are available through NNTP: e.g., at Gmane.org].
YMMV,
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
sites - e.g., Google - which maintain their own
internal threading of the discussion, but F_ up sending posts to the
list channel and breaking other's views of the discussion.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, 5 Apr 2017 11:39:17 -0700, John R Pierce
wrote:
>On 4/5/2017 11:30 AM, George Neuner wrote:
>> This makes it difficult to follow a discussion via email, and Google's
>> list handling is flawed - it sometimes breaks the underlying list
>> threading [while keeping
1 - 100 of 357 matches
Mail list logo
