On Wed, Sep 10, 2014 at 8:43 PM, Tom Lane wrote:
> You'd want to get a new version of the IANA timezone database files for
> that. Depending on what packaging you're using, this might be an
> operating-system update not a Postgres update. If you are relying
> on the Postgres copies, you'd have
Hi all
(This is really about the EDB installer, but we don't have anywhere
better to discuss it than -general, so):
The PostgreSQL installer now uses the NETWORKSERVICE account on Windows
by default (as of 9.2), instead of creating a "postgres" account with
username and password. Which is a big i
Vinayak writes:
> Is it possible to parse the CREATE SYNONYM statement and convert into CREATE
> VIEW statement using post_parse_analyze_hook? or is there any other idea to
> automate this process?
You will not be able to do it without modifying the grammar. SYNONYM
isn't even a keyword in stock
Hello,
>There are pros and cons to this approach. In general, I'd recommend
>using a simple view instead of trying to use the search_path- for
>example, prepared queries will look up the OID based on the current
>search_path. If you prepare a query, then change your search_path, and
>run tha
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 you can enable write caching for the device using the device
> manager. [Note that the device must be c
On 09/11/2014 05:50 AM, Steve Crawford wrote:
> 2. OS mismatch. Have you ensured that all client machines are running
> identical setups? The underlying files are not guaranteed portable
> between OS versions and 64/32-bit. In fact they probably won't be.
You can just run 32-bit Pg on both the 32-
Thank you Damien, issues updated. https://github.com/OPMDG/opm-core/issues/2
-Original Message-
From: damien clochard [mailto:dam...@dalibo.info]
Sent: Thursday, September 11, 2014 5:36 PM
To: Huang, Suya; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Introducing Open PostgreSQL Mon
Iain Mott writes:
> Here's what happens (the important error messages are in English):
> [~]# pg_dump mydatabase > dump.sql
> pg_dump: comando SQL falhou
> pg_dump: Mensagem de erro do servidor: ERROR: permission denied for schema
> topology
> pg_dump: O comando foi: LOCK TABLE topology.topolog
On 09/11/2014 04:37 AM, Iain Mott wrote:
Thanks a lot. Here is the response to
=> SELECT postgis_full_version();
postgi
So what does pgAdmin show for ownership of the schemas?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Wow, I was not expecting so many skillful feedbacks - Thanks to all
I am not closing the point yet since, as Steve Crawford suggested, the
solution I am looking for (as newbie) might not be optimal !-) So here is
more context.
All PCs run W7/64b (different hardware) and I will be the only u
Thanks a lot. Here is the response to
=> SELECT postgis_full_version();
postgi
s_full_version
Yep,
this means you are using postgis.
I don't know if you use postgis topology.
If you have a schema topology containing a topology table, then you also
have postgis_topology installed.
You can check this with this query : "SELECT postgis_full_version();"
Maybe the extensions have been created w
Thanks Rémi-C for the quick reply. By coincidence my site does involve
mapping, however I wasn't aware that the server might be using postgis
and postgis_topology. In psql when I type "\d" i get the following:
public | comentarios | tabela | myusername
public | featuredata | tabela
Hey,
if you are using postgis and postgis_topology,
there are specific backup/restore process.
Cheers,
Rémi-C
2014-09-11 12:49 GMT+02:00 Iain Mott :
> Hello,
>
> The server for my websites was recently changed and upgraded. I have ssh
> access to the server and since the upgrade I am no longer ab
Hello,
The server for my websites was recently changed and upgraded. I have ssh
access to the server and since the upgrade I am no longer able to use
"pg_dump" to perform scripted backups. I've written to the site's
support services, but until now, they've not been able to help (they've
responded
"McGehee, Robert" writes:
> SELECT n.node, sum(students) as students
> FROM tree_tbl t, node_tbl n
> WHERE t.course ~ '.*' || n.node || '.*'
> GROUP BY n.node;
I'd write this as
SELECT n.node, sum(students) AS students
FROM tree_tbl t
JOIN node_tbl n ON t.course ~ ('*.' || n.node || '.*')::lque
Le 11/09/2014 09:21, Huang, Suya a écrit :
> Has anyone tried the OPM? I followed the installation instruction and in the
> end I got a blank web page...
>
Hi,
We're trying to improve our documentation and especially the install
instructions. Can you provide more information about your setup
Has anyone tried the OPM? I followed the installation instruction and in the
end I got a blank web page...
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of damien clochard
Sent: Tuesday, September 09, 2014 1:23 AM
To: p
On Wed, 10 Sep 2014 14:19:45 -0700, John R Pierce
wrote:
>also, Windows disables writeback caching on external disks, this will
>greatly slow down update transactions.
Not exactly. By default, write caching is disabled for external
drives to support quick disconnect, i.e. yanking the device wi
On Thu, Sep 11, 2014 at 08:40:21AM +0200, Rémi Cura wrote:
> It is also easy to backup (but very slow due to huge iso file).
- rsync when you plug in
- make a copy
- rsync to copy continously during work
(note that this rsynced copy will be inconsistent,
it only serves to speed up the last st
20 matches
Mail list logo
