olution
of updating "master" and doing a full database drop and restore on the
"slaves". But I would like to know which of the other (real)
replication solutions might work for this use case.
Regards,
--Lee
--
Lee Hachadoorian
Assistant Professor of Instruction, Geography and Ur
On Mon, Sep 12, 2016 at 5:12 PM, Adrian Klaver
wrote:
> On 09/12/2016 12:46 PM, Lee Hachadoorian wrote:
>>
>> There are a wide variety of Postgres replication solutions, and I
>> would like advice on which one would be appropriate to my use case.
>>
>> * Small (~
the overall database organization might address both concerns.
Best,
--Lee
--
Lee Hachadoorian
Assistant Professor of Instruction, Geography and Urban Studies
Assistant Director, Professional Science Master's in GIS
Temple University
On Sun, Dec 4, 2016 at 4:24 PM, Paul Ramsey
wrote:
> When you create the student user, remove their create privs in public.
> Then create a scratch schema and grant them privs there.
> Finally, alter the student user so that the scratch schema appears FIRST
> in their search path. This will cause
s exist?
>
> Mainly I think it is the user interface and the fact that they are
> external. They don't look, act or feel like forums. Shrug. Further they
> aren't part of postgresql.org so nobody knows the level of real support
> they are going to get.
>
> JD
>
>
ran into the same persistence problem. Once "initialized" in one schema,
changing search_path to the other schema returns the correct current_schema
but the value from the table in the *other* schema (e.g. "var2,var1").
What am I missing?
Thanks,
--Lee
--
Lee Hachadoorian
Asst Professor of Geography, Dartmouth College
http://freecity.commons.gc.cuny.edu/
Merlin,
Perfect. Thank you.
Best,
--Lee
On Mon, Apr 1, 2013 at 10:04 AM, Merlin Moncure wrote:
> On Sun, Mar 31, 2013 at 5:32 PM, Lee Hachadoorian
> wrote:
> > I'm working on some PL/pgSQL functions to generate dynamic SQL. The
> > functions live in the public schema
hat I
will be saving for reuse.
version() = "PostgreSQL 9.1.8 on x86_64-unknown-linux-gnu, compiled by
gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit"
Regards,
--Lee
--
Lee Hachadoorian
Assistant Professor in Geography, Dartmouth College
http://freecity.commons.gc.cuny.edu
On 04/16/2013 07:31 PM, Adrian Klaver wrote:
On 04/16/2013 02:46 PM, Lee Hachadoorian wrote:
List,
SQL seems to be behaving in a case-sensitive manner:
universe=# select 1;
?column?
--
1
(1 row)
universe=# SELECT 1;
ERROR: syntax error at or near "SELECT 1&qu
On 04/16/2013 07:34 PM, Adrian Klaver wrote:
On 04/16/2013 02:46 PM, Lee Hachadoorian wrote:
List,
SQL seems to be behaving in a case-sensitive manner:
universe=# select 1;
?column?
--
1
(1 row)
universe=# SELECT 1;
ERROR: syntax error at or near "SELECT 1&qu
at must have been an email formatting thing. In psql, the caret is
under the S.
Looking at the other issues you raised, but just wanted to provide a
quick answer to that.
Best,
--Lee
--
Lee Hachadoorian
Assistant Professor in Geography, Dartmouth College
http://freecity.commons.gc.cuny.edu
On 04/16/2013 08:23 PM, Tom Lane wrote:
Lee Hachadoorian writes:
SQL seems to be behaving in a case-sensitive manner:
universe=# select 1;
?column?
--
1
(1 row)
universe=# SELECT 1;
ERROR: syntax error at or near "SELECT 1"
LINE 1: SELECT 1;
^
Tha
val_lower in sync and
discard all attempts to write directly to val_lower. Then all
queries would be of the form
SELECT id, val
FROM foo
WHERE val_lower LIKE 'ab%';
Wouldn't want to write every table like this, but if (a) query speed
trumps all othe
PostgreSQL directory has read/write access (it does). What else can I
try to start the server?
Thanks,
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
ured to) and when I try to start
it manually within the Component Services Manager, it generates the
following error:
Error 1069: The service did not start due to a logon failure.
Thanks,
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center
On We
is installed. If it weren't, you would get
pg_wrapper: command not found
The issue is that it seems raster2pgsql and shp2pgsql are not
installed. You cannnot "enable" them by making them each a link to
pg_wrapper.
You might want to bring this back to the PostGIS list, be
LTER TABLE.
Thanks,
--Lee
--
Lee Hachadoorian
Asst Professor of Geography, Dartmouth College
http://freecity.commons.gc.cuny.edu/
--
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, Nov 16, 2012 at 10:11 AM, Lee Hachadoorian
> wrote:
>>
>> How can I read the current storage parameters for an existing table?
>> Specifically interested in autovacuum_enabled.
On Fri, Nov 16, 2012 at 12:08 PM, Mike Blackwell wrote:
> Try pg_cla
Nx languages. If I ever try to COPY FROM data incompatible with
LATIN1, the command will just choke, and I can pick an appropriate
encoding and try again, right?
Thanks,
--Lee
--
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center
--
Sent via
regards, tom lane
>
So, IIUC, the general approach is:
*Leave the default client_encoding = server_encoding (in this case UTF8)
*Rely on the client to change client_encoding on a session basis only
Thanks,
--Lee
--
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Enviro
quarters.
Thanks,
--Lee
--
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
terly data out of sight.
Thanks for your replies. Please feel free to comment if you think of
anything else.
Best,
--Lee
--
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
g lost after ~ 15-20 minutes of
inactivity.
Thanks,
--Lee
--
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
eway?
>
> 15-20 mins sounds a lot like the typical NAT idle connection timeout...
I will have to ask the network administrator and respond.
Thanks,
--Lee
--
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center
--
Sent via pgsql-ge
John,
Just wanted to reply that this seems to have been the right track.
Rather than change the firewall settings, our network administrator
was able set postgres to send a keepalive to the client.
Thanks,
--Lee
On Thu, Mar 4, 2010 at 5:26 PM, Lee Hachadoorian
wrote:
> On Thu, Mar 4, 2010 a
e data all in one row? If numeric types
are un-TOASTable, 23k columns will necessarily break the 8k limit even
if they were all smallint, correct?
Regards,
--Lee
--
Lee Hachadoorian
PhD, Earth& Environmental Sciences (Geography)
Research Associate, CUNY Center for Urban Research
http://freec
On 10/26/2011 12:31 AM, David Johnston wrote:
On Oct 25, 2011, at 22:17, Lee Hachadoorian wrote:
I need some advice on storing/retrieving data in large rows. Invariably someone
points out that very long rows are probably poorly normalized, but I have to
deal with how to store a dataset
On Wed, Oct 26, 2011 at 10:15 AM, Simon Riggs wrote:
> On Wed, Oct 26, 2011 at 2:57 PM, Lee Hachadoorian
> wrote:
>
> > Interesting. Although your example of one, 10-dimension array works,
> > five hundred 2-dimension arrays does not work. I can do the SELECT, but
&
ql-general/2011-08/msg00144.php) If
this is the case, what does "a precision of at least [x] digits"
actually mean? And can I reliably retrieve the original integer by
casting to int (or bigint) if the number of digits in the original
integer is less than 15?
Regards,
--Lee
--
On 11/20/2011 02:06 PM, Tom Lane wrote:
Lee Hachadoorian writes:
And can I reliably retrieve the original integer by
casting to int (or bigint) if the number of digits in the original
integer is less than 15?
On IEEE-floating-point machines, I'd expect float8 to store integers
up to 2^5
to high).
Any insight?
Regards,
--Lee
--
Lee Hachadoorian
PhD, Earth & Environmental Sciences (Geography)
Research Associate, CUNY Center for Urban Research
http://freecity.commons.gc.cuny.edu/
have to try to benchmark some different
approaches, but for now planning on using array columns, with each
"sequence" (in the Census sense, not the Postgres sense) of 200+
variables in its own array rather than its own table.
--Lee
--
Lee Hachadoorian
PhD, Earth& Environmental S
ces into array columns. The subject tables would
still be views.
--Lee
--
Lee Hachadoorian
PhD, Earth & Environmental Sciences (Geography)
Research Associate, CUNY Center for Urban Research
http://freecity.commons.gc.cuny.edu/
to use a DDL trigger seems like a
roundabout way to get what you want when the problem is ogr2ogr.
So, I would back up and ask, what are you trying to do, and what
information is being lost using -append?
Also, you mentioned asking this on the GDAL list, did you try the PostGIS
list?
--Lee
On Tue, Mar 20, 2012 at 11:28 PM, Jim Green
wrote:
> On 20 March 2012 22:57, John R Pierce wrote:
>
> > avg() in the database is going to be a lot faster than copying the data
> into
> > memory for an application to process.
>
> I see..
>
As an example, I ran average on a 700,000 row table with
On Wed, Mar 21, 2012 at 12:57 PM, Andy Colson wrote:
> On 3/21/2012 11:45 AM, Lee Hachadoorian wrote:
>
>>
>>
>>On 20 March 2012 22:57, John R Pierce ><mailto:pie...@hogranch.com>> wrote:
>>
>> > avg() in the database is going
;;
END;
2) Is there a performance hit to doing a COPY to more than one table
in the same transaction?
Any other advice will be appreciated.
Regards,
--Lee
--
Lee Hachadoorian
PhD, Earth & Environmental Sciences (Geography)
Research Associate, CUNY Center for Urban Research
http://freecity.c
On Thu, May 10, 2012 at 2:42 PM, Andy Colson wrote:
> On 5/10/2012 1:10 PM, Lee Hachadoorian wrote:
>>
>> 2) Is there a performance hit to doing a COPY to more than one table
>> in the same transaction?
>
>
> No, I don't think so. I assume you are the only
ot-very-obvious "Show [x]
technical items" link at the bottom of the window. I would recommend
using apt (command line) or Synaptic (graphical) instead of Software
Center.
sudo apt-get install postgresql postgresql-contrib
should get you started.
--Lee
39 matches
Mail list logo
