te a new
cluster. You'll have to reload your databases from backups.
But I would be concerned that the disk structure is damaged. I would
run e2fsck on it - and if there are lots of errors found I wouldn't
use it.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
Tomas's suggestion definitely is the better if you're altering the
type of a single column. If you need to make more extensive changes
to the table structure, copying usually is the better way to go.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
new table into service.
You need to do a final check for and copy of any updates to the
original that might have snuck in while processing the last batch. And
lastly you can drop the source table.
It won't be fast, but it also won't paralyze your database while its
working.
>Thanks,
>Jon
nal aware programs in the VM to save state before being suspended.
WRT shapshot integrity, I don't think the latter really adds much, but
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
On Wed, 20 Sep 2017 20:24:05 +0200, "Klaus P. Pieper"
<kpi6...@gmail.com> wrote:
>> Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
>> ow...@postgresql.org] Im Auftrag von George Neuner
>>
>> But VSS is needed only to copy VM files *whi
lable if you install the Data Recovery extensions.
FWIW, Virtualbox doesn't provide VSS support either.
But VSS is needed only to copy VM files *while* they are in use. If
you snapshot the VM, the snapshot files then are read-only and can be
freely copied. As long as the backup avoids the c
it's not so
good.
If the database files on the VM's "drive" develop errors, those errors
will be preserved in the VM backup.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
timestamp+counter approach. I wasn't
thinking about this issue specifically, but it is immune to the
counter being reset [accidentally or otherwise].
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.io/2014/05/28/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
ok up odcivarchar2list - according to the Oracle docs it is
a 'varray(m) of varchar(n)'.
The equivalent in Postgresql would be 'varchar(n)[m]'.
https://www.postgresql.org/docs/9.6/static/arrays.html
Hope this helps.
George
--
Sent via pgsql-general mailing list (pgsql-general@postg
;\\shared\network\path\to\csv\test.csv" for reading: No such file or
>directory*
>
Francisco already pointed out that Linux doesn't understand the
backslashes in the file path, however it should be noted that Windows
*does* understand forward slashes and that [modulo disk names in
Win
On Thu, 31 Aug 2017 13:20:27 -0700, "David G. Johnston"
<david.g.johns...@gmail.com> wrote:
>On Thu, Aug 31, 2017 at 1:04 PM, George Neuner <gneun...@comcast.net> wrote:
>
>> Does anyone know a way to do this reliably?
>
>?The psql "\copy" meta-
of hours now and I can't find a solution
that works. No matter what I try I get "invalid input syntax for type
..." when import hits the first null value.
Does anyone know a way to do this reliably?
Thanks,
George
--
Sent via pgsql-general mailing list (pgsql-general@postgres
__int64", or "long long" (with or without space). Or
search the headers for a *_MAX constant equal to 9223372036854775807.
[i.e. (2^63)-1]
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 file specify from where
the client(s) can connect.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nstraint on B. I don't think that will make any
difference to the query plan ... AFAICS, it still needs to consider
all partitions of A ... but it may improve performance.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
so people wanting to
create symlinks were forced to use the sysinternals junction utility.
https://technet.microsoft.com/en-us/sysinternals/bb545021.aspx
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Its
documentation does not describe the differences, but is shows that
hard links, symlinks, and junctions all are distinct concepts in
Windows.
https://technet.microsoft.com/en-us/library/cc753194(v=ws.11).aspx
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
as in Unix/Linux.
Local loopback connections on Windows are made using normal TCP or UDP
sockets. You need to configure permissions as with any remote client,
only specifying the localhost addresses 127.0.0.1 and/or ::1.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql
haps it's time to lose
the naked username? How many people actually use that syntax vs some
other method: sudo, .pgpass, environment variables, etc. ?
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
ers of web forums often assume *you* can
easily look back up the thread because *they* can. In my experience,
it isn't always easy to do.
YMMV,
George
[*] where is a "gagging" emoji when you really need one?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
ia a library/driver.
>3) Can PostgreSQL be made to work seamlessly to take advantage of the
>superior performance of HHVM or Node.js?
Not really sure what you're asking. The application running under
HHVM or node.js is completely separate from Postgresql.
Both PHP and Javascript (generic
On Thu, 20 Apr 2017 07:56:18 -0700, Rj Ewing <ewing...@gmail.com>
wrote:
>On Wed, Apr 19, 2017 at 6:44 PM, George Neuner <gneun...@comcast.net> wrote:
>>
>> If you can restrict the FTS query to certain keys:
>>
>> SELECT id FROM mytable
>> WHERE
On Thu, 20 Apr 2017 08:50:31 -0700, Rj Ewing <ewing...@gmail.com>
wrote:
>On Wed, Apr 19, 2017 at 9:55 PM, George Neuner <gneun...@comcast.net> wrote:
>
>> ... Since you are *testing* with 1M records (that
>> create 44M k:v shards), I am assuming you will need
On Thu, 20 Apr 2017 00:55:48 -0400, George Neuner
<gneun...@comcast.net> wrote:
Doh!
> SELECT count(distinct s.id)
>FROM samples_lg_txt AS s
>JOIN keys AS k ON k.id = s.key
>WHERE (k.name = 'key1' AND s.tsv @@ to_query('value1')
> OR (k.name = 'key2'
lg_txt
WHERE (key = 'key1' AND tsv @@ to_query('value1')
OR (key = 'key2' AND tsv @@ to_query('value2')
Just a reminder [it's late here 8-)]: FK columns contain values - not
weird references to the foreign tables. The constraint just enforces
that any value inserted/updated into the
table and its indexes, and all
the query workspaces, then I doubt you will be able to get anywhere
near your optimistic execution target for FTS on 40+ million rows.
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
anced crash resistance against
increased SSD wear and (slightly) reduced write performance.
See:
fsutil usn ...
https://technet.microsoft.com/en-us/library/cc788042(v=ws.11).aspx
fsutil repair ...
https://technet.microsoft.com/en-us/library/ff621565(v=ws.11).aspx
George
--
Sent via pgsql-gener
ze the writes will
>take longer)?
>
>the nature of our data is "relatively" static with bulk uploads (100 - 1000
>records). So we can sacrifice some write performance.
>
>RJ
Having to "reconstruct" records will make reads take longer as well,
but I think separating
nversation that isn't in their inbox. Asking for
>a "forum" seems to be expressing a problem of this nature. I'm deferring
>consideration of this problem-area for some other time.
That's [partly] what digest mailings are for ... to alert people to
interesting discussions they aren't following. U
o the question is, what is the problem we are trying to solve?
How to support BOTH quick and dirty questions:answers AND complex
technical discussions that require significant time from their
participants.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make cha
On Wed, 5 Apr 2017 11:39:17 -0700, John R Pierce <pie...@hogranch.com>
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
>> t
t], and broken threads 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
ess efficient than Unix/Linux 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
, but the 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
historical (hysterical?) reasons, I use Forte Agent as my reader on
Windows, but Thunderbird and SeaMonkey both work well for news and are
cross platform.
YMMV,
George
[*] Gmane is one of the list<>news bridges. They currently are in the
midst of rehosting and changing maintainers. The N
On Mon, 20 Mar 2017 12:05:01 +0100, Karsten Hilbert
<karsten.hilb...@gmx.net> 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 notificati
gresql as an application, you need to stop the cluster
manually before shutting down, or sleeping, etc.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
os.d.
>From that point, yum 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 sub
Hi David,
On Sat, 4 Mar 2017 02:32:48 +1300, David Rowley
<david.row...@2ndquadrant.com> wrote:
>On 3 March 2017 at 18:26, George Neuner <gneun...@comcast.net> wrote:
>> I know most people here don't pay much - or any - attention to
>> SQLServer, however there
citly stated, it hints 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 li
to issue a "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
led* clients direct 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
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:19 AM
On Thu, Dec 1, 2016 at 6:58 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> George <pinkisntw...@gmail.com> writes:
>> explain analyze select *
>> from wg3ppbm_transaction where partner_uuid in (
>> select p.uuid
>> from wg3ppbm_userpartner
On Wed, Nov 30, 2016 at 10:08 PM, George <pinkisntw...@gmail.com> wrote:
> On Wed, Nov 30, 2016 at 8:44 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
>> Merlin Moncure <mmonc...@gmail.com> writes:
>>> On Wed, Nov 30, 2016 at 11:05 AM, George <pinkisntw...@gmail.
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
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 Wed, Nov 30, 2016 at 8:44 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Merlin Moncure <mmonc...@gmail.com> writes:
>> On Wed, Nov 30, 2016 at 11:05 AM, George <pinkisntw...@gmail.com> wrote:
>>> So there is definitely something wrong here. This situation m
On Wed, Nov 30, 2016 at 6:45 PM, Merlin Moncure <mmonc...@gmail.com> wrote:
> On Wed, Nov 30, 2016 at 10:42 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
>> George <pinkisntw...@gmail.com> writes:
>>> explain select * from wg3ppbm_transaction where partner_uui
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
))
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
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 insta
that you talk 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-gen
uniqueness 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
;embedded", like SQLite. But 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
or a simple 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
txt text := 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 mak
n Linux (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-gen
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
/headers " on the 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
tem 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
launch 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
Column store enhances 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 y
t; tables 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-
eed even if it's issue time 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
>
>> > > 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
On Fri, 12 Feb 2016 14:43:55 -0800, John R Pierce
<pie...@hogranch.com> 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 "d
aware of
many of the 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
n 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:
h
With 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:
h
S Networks
www.iglass.net
On Thu, Dec 31, 2015 at 2:29 PM, George Woodring <george.woodr...@iglass.net
> 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 po
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 <adrian.kla...@aklaver.com>
wrote:
> On 12/31/2015 11:29 AM, George Woodr
ged to. Obviously there 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 pgs
O distro at all
that enables 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
lot of users x columns,
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
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 pgsql-g
On Sun, 29 Nov 2015 05:04:42 -0500, "Steve Petrie, P.Eng."
<apet...@aspetrie.net> wrote:
>"George Neuner" <gneun...@comcast.net> wrote in message
>news:kaed5btl92qr4v8ndevlgtv0f28qaae...@4ax.com...
>
>> My vote for an email client would be Thund
regardless of deletions 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
and the reason for "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
ectly requires Outlook be 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
???
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:
http://www.postgresql.org/mailpref/pgsql-general
- 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
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://www.postgresql.org
timezone. Then you only have one offset, US/East -- UTC.
We originally did it for simplicity sake, the database is set for our
customer's timezone. So when we grabbed a date from the db, it would in
the correct timezone for the viewer, without the web code having to know
the timezone.
George Woodring
-- 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
it at 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
to
timezone y.
George Woodring
iGLASS Networks
www.iglass.net
On Mon, Feb 23, 2015 at 9:16 AM, Dave Cramer p...@fastcrypt.com wrote:
Well you could always just put it back to whatever you want when you open
the connection ie set timezone
Dave Cramer
dave.cramer(at)credativ(dot)ca
http
/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 t...@sss.pgh.pa.us wrote:
George Woodring george.woodr...@iglass.net writes:
Yes, that is where we think
/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
Sent: Friday
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 reasonable thing
Hi Adrian,
From: Adrian Klaver adrian.kla...@aklaver.com
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
Hi Adrian,
From: Adrian Klaver adrian.kla...@aklaver.com
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
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
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 adrian.kla...@aklaver.com
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
Sorry for the late reply...life interefered...
From: Jim Nasby jim.na...@bluetreble.com
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
).
--
-- 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
and then 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.org
1 - 100 of 352 matches
Mail list logo
