Re: [GENERAL] Regarding timezone
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 to update src/timezone/data/ and > then do a "make install" in src/timezone. > > regards, tom lane > Thanks Tom ! Actually am using the postgres binaries and not building from sources. Is there any solution if using the binaries and want to update timezone settings? Regards...
[GENERAL] PostgreSQL service account on Windows 7: Use a virtual account
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 improvement to usability. I recently found out that on Windows 7 / win2k8 R2 and newer there's now a better alternative available: virtual accounts and managed service accounts. They combine the benefit of avoiding all that password management cruft with the ability to run services in less-privileged, better isolated accounts. See "New Account Types Available with Windows 7 and Windows Server 2008 R2" in http://msdn.microsoft.com/en-au/library/ms143504.aspx particularly "virtual accounts". If that looks a lot like a UNIX "system account", you're not mistaken. It looks like Microsoft have finally figured out that it'd be nice not to need a password for a background system service and to have to then store that password somewhere on the same system. It may be worth adopting this when the installer detects a Windows 7 / Win2k8 R2 or newer system - just create an account like: NT Service\PostgreSQL$EDB-9.4-x86 (or whatever name will get rid of conflicts) and use that instead of NETWORK SERVICE. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] CREATE SYNONYM in PostgreSQL
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 PG. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] CREATE SYNONYM in PostgreSQL
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 that prepared query, it's going to use the table which was resolved >using the search_path when the query was initially planned. I agreed to use view instead of search_path. >> Is there any way to automate the oracle's CREATE SYNONYM in PostgreSQL or >> can we use hook like post_parse_analyze_hook to implement this? >You could try but that doesn't seem likely to work out too well.. I want to convert Oracle CREATE SYNONYM statement into PostgreSQL CREATE VIEW statement in my own extension not in the PostgreSQL core. 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? - Regards, Vinayak, -- View this message in context: http://postgresql.1045698.n5.nabble.com/CREATE-SYNONYM-in-PostgreSQL-tp5818446p5818755.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL Portable
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 connected for it to be visible > in the device manager.] It shouldn't be living dangerously, actually. While I haven't tested it myself, writeback caching on the external drive should be safe so long as it continues to honour explicit disk flush requests. That's why we have the WAL and do periodic checkpoints. If you yank the drive mid-write you'll lose uncommitted transactions and might have slower startup next time around, but it should otherwise not be overly problematic. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL Portable
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-bit and 64-bit hosts without problems. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Introducing Open PostgreSQL Monitoring (OPM)
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 Monitoring (OPM) 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 and declare teh issue here : https://github.com/OPMDG/opm-core/issues Thanks in advance -- Damien -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] permission denied for schema topology
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.topology IN ACCESS SHARE MODE > I am able to perform dumps of the databases via phpPdAdmin in the > "cpanel" of the server, but this is going very inconvenient - hoping to > use pg_dump If it works through phpPgAdmin, then phpPgAdmin must be using some other (more privileged) user ID than what pg_dump is using by default. A simple workaround therefore ought to be to use pg_dump's -U switch to use that other user ID. >From the rest of the thread I gather that you ought to complain to your service provider that they installed postgis when you didn't ask for it. But selecting the right user ID to dump as is important anyway; it generally doesn't work to use an underprivileged ID for pg_dump. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] permission denied for schema topology
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) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL Portable
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 user accessing the DB. Once the setup completed, the DB will mainly be used for reading the data (requests). The results will be used for statistical analysis/data representation. Thank again. Daniel
Re: [GENERAL] permission denied for schema topology
Thanks a lot. Here is the response to => SELECT postgis_full_version(); postgi s_full_version - POSTGIS="2.0.1 r9979" GEOS="3.3.5-CAPI-1.7.5" PROJ="Rel. 4.8.0, 6 March 2012" G DAL="GDAL 1.9.1, released 2012/05/15 GDAL_DATA not found" LIBXML="2.7.6" TOPOLOG Y RASTER (1 registro) Em Qui, 2014-09-11 às 13:21 +0200, Rémi Cura escreveu: > 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 with another user id than > your's, hence the trouble. > > Another trouble could come from the fact that postgis and > postgis_topology may have been installed without using postgres > CREAtE EXTENSION (old version of postgis). > > > > Cheers, > Rémi-C > > > 2014-09-11 13:12 GMT+02:00 Iain Mott : > 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 | myusername > public | geography_columns | visão | myusername > public | geometry_columns | visão | myusername > public | raster_columns| visão | myusername > public | raster_overviews | visão | myusername > public | rss | tabela | myusername > public | spatial_ref_sys | tabela | myusername > > geography_columns, geometry_columns, raster_columns, > raster_overviews > and spatial_ref_sys are all recent changes to my database (I > didn't > create them and I wasn't aware of their existence until the > switch to > the new server). Do these and the errors I'm receiving > indicate the use > of postgis and postgis_topology by the server? > > Just googled for doing a dump of a postgis database and > encountered this > command: > > pg_dump --no-acl --no-owner $DATABASE > dump.sql > > I tried it, but it results in the same error messages > > Cheers, > > > > > > > > > > Em Qui, 2014-09-11 às 12:53 +0200, Rémi Cura escreveu: > > 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 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 saying they will likely need to refer the > case on to > > a > > developer - I don't have any guarantees that it > will be > > resolved). > > > > I've googled for this - but didn't come up with any > relevant > > solutions. > > Can someone on this list please make suggestions > that I can > > pass on to > > the technical support? > > > > Here's what happens (the important error messages > are in > > English): > > > > > > [~]# pg_dump mydatabase > dump.sql > > Senha: > > 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.topology > IN ACCESS > > SHARE MODE > > > > > > --- > > > > I am able to perform dumps of the databases via > phpPdAdmin in > > the > > "cpanel" of the server, but this is going very >
Re: [GENERAL] permission denied for schema topology
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 with another user id than your's, hence the trouble. Another trouble could come from the fact that postgis and postgis_topology may have been installed without using postgres CREAtE EXTENSION (old version of postgis). Cheers, Rémi-C 2014-09-11 13:12 GMT+02:00 Iain Mott : > 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 | myusername > public | geography_columns | visão | myusername > public | geometry_columns | visão | myusername > public | raster_columns| visão | myusername > public | raster_overviews | visão | myusername > public | rss | tabela | myusername > public | spatial_ref_sys | tabela | myusername > > geography_columns, geometry_columns, raster_columns, raster_overviews > and spatial_ref_sys are all recent changes to my database (I didn't > create them and I wasn't aware of their existence until the switch to > the new server). Do these and the errors I'm receiving indicate the use > of postgis and postgis_topology by the server? > > Just googled for doing a dump of a postgis database and encountered this > command: > > pg_dump --no-acl --no-owner $DATABASE > dump.sql > > I tried it, but it results in the same error messages > > Cheers, > > > > > > > > > > Em Qui, 2014-09-11 às 12:53 +0200, Rémi Cura escreveu: > > 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 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 saying they will likely need to refer the case on to > > a > > developer - I don't have any guarantees that it will be > > resolved). > > > > I've googled for this - but didn't come up with any relevant > > solutions. > > Can someone on this list please make suggestions that I can > > pass on to > > the technical support? > > > > Here's what happens (the important error messages are in > > English): > > > > > > [~]# pg_dump mydatabase > dump.sql > > Senha: > > 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.topology IN ACCESS > > SHARE MODE > > > > > > --- > > > > I am able to perform dumps of the databases via phpPdAdmin in > > the > > "cpanel" of the server, but this is going very inconvenient - > > hoping to > > use pg_dump > > > > Thanks, > > > > > > > > -- > > Sent via pgsql-general mailing list > > (pgsql-general@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-general > > > > > > >
Re: [GENERAL] permission denied for schema topology
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 | myusername public | geography_columns | visão | myusername public | geometry_columns | visão | myusername public | raster_columns| visão | myusername public | raster_overviews | visão | myusername public | rss | tabela | myusername public | spatial_ref_sys | tabela | myusername geography_columns, geometry_columns, raster_columns, raster_overviews and spatial_ref_sys are all recent changes to my database (I didn't create them and I wasn't aware of their existence until the switch to the new server). Do these and the errors I'm receiving indicate the use of postgis and postgis_topology by the server? Just googled for doing a dump of a postgis database and encountered this command: pg_dump --no-acl --no-owner $DATABASE > dump.sql I tried it, but it results in the same error messages Cheers, Em Qui, 2014-09-11 às 12:53 +0200, Rémi Cura escreveu: > 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 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 saying they will likely need to refer the case on to > a > developer - I don't have any guarantees that it will be > resolved). > > I've googled for this - but didn't come up with any relevant > solutions. > Can someone on this list please make suggestions that I can > pass on to > the technical support? > > Here's what happens (the important error messages are in > English): > > > [~]# pg_dump mydatabase > dump.sql > Senha: > 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.topology IN ACCESS > SHARE MODE > > > --- > > I am able to perform dumps of the databases via phpPdAdmin in > the > "cpanel" of the server, but this is going very inconvenient - > hoping to > use pg_dump > > Thanks, > > > > -- > Sent via pgsql-general mailing list > (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] permission denied for schema topology
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 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 saying they will likely need to refer the case on to a > developer - I don't have any guarantees that it will be resolved). > > I've googled for this - but didn't come up with any relevant solutions. > Can someone on this list please make suggestions that I can pass on to > the technical support? > > Here's what happens (the important error messages are in English): > > > [~]# pg_dump mydatabase > dump.sql > Senha: > 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.topology IN ACCESS SHARE MODE > > > --- > > I am able to perform dumps of the databases via phpPdAdmin in the > "cpanel" of the server, but this is going very inconvenient - hoping to > use pg_dump > > Thanks, > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
[GENERAL] permission denied for schema topology
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 saying they will likely need to refer the case on to a developer - I don't have any guarantees that it will be resolved). I've googled for this - but didn't come up with any relevant solutions. Can someone on this list please make suggestions that I can pass on to the technical support? Here's what happens (the important error messages are in English): [~]# pg_dump mydatabase > dump.sql Senha: 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.topology IN ACCESS SHARE MODE --- I am able to perform dumps of the databases via phpPdAdmin in the "cpanel" of the server, but this is going very inconvenient - hoping to use pg_dump Thanks, -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Aggregating over nodes in hierarchical trees
"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 || '.*')::lquery
GROUP BY n.node;
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Introducing Open PostgreSQL Monitoring (OPM)
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 and declare teh issue here : https://github.com/OPMDG/opm-core/issues Thanks in advance -- damien -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Introducing Open PostgreSQL Monitoring (OPM)
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: pgsql-general@postgresql.org Subject: [GENERAL] Introducing Open PostgreSQL Monitoring (OPM) # Introducing Open PostgreSQL Monitoring (OPM) ## Oversee and Manage Your PostgreSQL Servers _Paris, September 8th 2014_ The OPM Development Group (see below) is proud to present the first public release of Open PostgreSQL Monitoring, a fully open source monitoring suite for PostgreSQL. ## Get Graphs and Stats from your PostgreSQL instances! PostgreSQL may be the most advanced database in the world but one of its biggest handicap is the lack of open source dedicated monitoring tools. Compared to its competitors, the PostgreSQL community has not been able to produce tools similar to Oracle Grid Control, MySQL Workbench or SQL Server Management Studio. Today we'd like to present the OPM project: a fully open-source suite designed to provide dynamic graphs, custom stats series, performance analysis, server health overview and team management... If you have serveral postgres servers in production, Open PostgreSQL Monitoring is the perfect to watch the current activity of your databases, with DBA-centric stats such as: database size, hit ratio, streaming replication lag, system load, page bloat, longest queries, WAL files generation, locks, backends status, etc. ## Extensibility is the key This initial public version is obviously a first step toward more features and more versatility. OPM includes remote agents, a stat storage system and a web GUI. Most of the code is currently in Perl and the stat collection is based on Nagios, but the whole suite is designed to be extended to other monitoring frameworks and other languages. It is possible to your own remote agent, a specific stat storage or even an alternative user interface. The OPM project was started in 2012 and it's been used in production for months, monitoring dozens of servers like a charm. We're publishing today the version 2.3 with the hope that it will be useful for other PostgreSQL users around the world. ## Credits The OPM Development Group would like to thank all the developers who contributed to this release, especially Sebastien Fauveau from [Art is Code](http://a.rtisco.de/) for his UI/UX design skills. OPM is an open project available under the PostgreSQL License. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the GitHub tools or directly to cont...@opm.io ## Links * Website : [http://opm.io/](http://opm.io/) * Demo : [http://demo.opm.io](http://demo.opm.io) (login/pass = opm/demo) * twitter : [@__opm__](http://twiter.com/__opm__) -- **About OPM** : Open PostgreSQL Monitoring is a free software designed to help you manage your PostgreSQL servers. It's a flexible tool that will follow the activity of each instance. It can gather stats, display dashboards and send warnings when something goes wrong. The long-term goal of the project is to provide similar features to those of Oracle Grid Control or SQL Server Management Studio. Code & Demo at [http://opm.io/](http://opm.io/) -- **About the OPM Development Group** : This project is driven by the OPM Development Group (OPMDG), a team of developers gathered to build efficient monitoring tools for PostgreSQL. So far the main sponsor of this project is DALIBO, the leading PostgreSQL company in France. However the project team is open to ideas and contributions: individuals and companies who share the goals of the OPMDG are welcome to join the team! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL Portable
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 without unmounting it. 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 connected for it to be visible 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: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL Portable
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 step) - final rsync to copy after you shut down the virtual machine before you unplug the external disk - delete the initial rsync (which was the copy _before_ this session) Should be acceptably fast even with large VMs. Karsten -- GPG key ID E4071346 @ gpg-keyserver.de E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
