Restoring 9.1 db from crashed disk/VM

insights Robert

the installation of pgadmin4 makes me weep in frustration

doku on how to install pgadmin4. Preferably I would like to install it using pip? thanks robert -- Robert Rottermann CEO 031 333 10 20 rob...@redo2oo.ch <mailto:rob...@redo2oo.ch> Sickingerstrasse 3, 3014 Bern <http://maps.apple.com/?q=Sickingerstrasse 3,3014 Bern> https://Redo2

Re: pgadmin4: not possible to create server

I can connect any more ideas? robert On Tue, Feb 6, 2018 at 10:54 PM, robert rottermann <mailto:rob...@redcor.ch>>wrote: Hi there, I have installed pgadmin4 locally using its docker image. this i did running the following command: docker run -p 80:80 -e "PGADMIN_DEF

Re: pgadmin4: not possible to create server

On 06.02.2018 18:28, Adrian Klaver wrote: On 02/06/2018 09:24 AM, robert rottermann wrote: Hi there, I have installed pgadmin4 locally using its docker image. this i did running the following command: docker run -p 80:80 -e "PGADMIN_DEFAULT_EMAIL=admin" -e "PGADMIN_DEFAULT

Re: pgadmin4: not possible to create server

On 06.02.2018 23:12, Adrian Klaver wrote: On 02/06/2018 02:08 PM, robert wrote: On 06.02.2018 18:28, Adrian Klaver wrote: On 02/06/2018 09:24 AM, robert rottermann wrote: Hi there, I have installed pgadmin4 locally using its docker image. this i did running the following command

Re: pgadmin4: not possible to create server

On 06.02.2018 23:12, Adrian Klaver wrote: On 02/06/2018 02:08 PM, robert wrote: On 06.02.2018 18:28, Adrian Klaver wrote: On 02/06/2018 09:24 AM, robert rottermann wrote: Hi there, I have installed pgadmin4 locally using its docker image. this i did running the following command

solution: Re: pgadmin4: not possible to create server

teway": "",     "GlobalIPv6Address": "",     "GlobalIPv6PrefixLen": 0,     "MacAddress": "02:42:ac:11:00:02",     "DriverOpts": null     } so postgres runs on 172.17.0.1 and bingo, it works thanks again robert

Re: pgadmin4: not possible to create server

On 06.02.2018 23:33, Adrian Klaver wrote: On 02/06/2018 02:19 PM, robert wrote: So you pgAdmin4 running in a container on your local machine and Postgres running in the native OS(the OS is?) on your local machine. Is the Docker container set up to 'see' the local machine? w

Re: pgadmin4: not possible to create server

I can connect any more ideas? robert On Tue, Feb 6, 2018 at 10:54 PM, robert rottermann <mailto:rob...@redcor.ch>>wrote: Hi there, I have installed pgadmin4 locally using its docker image. this i did running the following command: docker run -p 80:80 -e "PGADMIN_DEF

Re: pgadmin4: not possible to create server

On 06.02.2018 18:28, Adrian Klaver wrote: On 02/06/2018 09:24 AM, robert rottermann wrote: Hi there, I have installed pgadmin4 locally using its docker image. this i did running the following command: docker run -p 80:80 -e "PGADMIN_DEFAULT_EMAIL=admin" -e "PGADMIN_DEFAULT

Query hitting empty tables taking 48 minutes

on blob (cost=0.57..4.42 rows=1 width=75) (actual time=0.037..0.037 rows=1 loops=5) Index Cond: (id = job_entry.blob_id) Planning time: 6.330 ms Execution time: 1951.564 ms Please keep my CC of my work e-mail present. Best, Robert

Re: Query hitting empty tables taking 48 minutes

> On Jun 7, 2018, at 12:40 PM, Adrian Klaver wrote: > > On 06/07/2018 11:17 AM, Robert Creager wrote: >> I have a system running FreeBSD 11.1-STABLE, PostgreSQL 9.6.8,Java OpenJDK >> 1.8.0_131, jdbc 9.3-1104-jdbc41 which is exhibiting very bizarre behavior. >> A q

Re: Query hitting empty tables taking 48 minutes

> On Jun 7, 2018, at 1:14 PM, Adrian Klaver wrote: > > On 06/07/2018 11:55 AM, Robert Creager wrote: >>> On Jun 7, 2018, at 12:40 PM, Adrian Klaver >> <mailto:adrian.kla...@aklaver.com>> wrote: >>> >>> On 06/07/2018 11:17 AM, Robert Creag

Re: Query hitting empty tables taking 48 minutes

> On Jun 7, 2018, at 3:34 PM, Tom Lane wrote: > > Robert Creager writes: >> Jun 7 17:24:21 blackpearl postgres[10670]: [7737-1] >> db=tapesystem,user=Administrator,app=[unknown],client=127.0.0.1 LOG: >> duration: 2903612.206 ms execute fetch from S_2037436/C

Re: Query hitting empty tables taking 48 minutes

Re-sending from a subscribed address (sigh). On Jun 7, 2018, at 4:18 PM, Robert wrote: > On Jun 7, 2018, at 2:15 PM, Laurenz Albe <mailto:laurenz.a...@cybertec.at>> wrote: > > Robert Creager wrote: >> I have a system running FreeBSD 11.1-STABLE, PostgreSQL 9.6.8,Ja

Re: Query hitting empty tables taking 48 minutes

> On Jun 7, 2018, at 4:58 PM, David G. Johnston > wrote: > > On Thu, Jun 7, 2018 at 3:02 PM, Robert Creager <mailto:rob...@logicalchaos.org>> wrote: > ​[...]​ > job_id | f | 1 | cc54ca5d-0dca-4b35-acd9-e0fe69c6b247 > > IIUC, the syst

Re: Query hitting empty tables taking 48 minutes

ave an affect of this magnitude on the database, although I’d love to be told otherwise. Best, Robert

Re: Query hitting empty tables taking 48 minutes

s3 blob303498 2559303496 2 0 2 5000 2018-06-08 04:35:00.00 NULLfalse 0 ds3 job_entry 303659 815 303659 0 0 0 5000 2018-06-08 04:35:00.00 NULLfalse 0 Best, Robert

Re: Query hitting empty tables taking 48 minutes

> On Jun 7, 2018, at 4:18 PM, Robert wrote: > >> You can capture the execution plan of the bad statement by using >> auto_explain, >> that would certainly shed more light on the problem. > A different query started showing up as the problem, the auto_explain wi

Re: Query hitting empty tables taking 48 minutes

> On Jun 18, 2018, at 4:04 PM, Laurenz Albe wrote: > > Robert Creager wrote: >> A different query started showing up as the problem, the auto_explain with >> analyze shows an oddity, >> the total query duration is 11k seconds, while the query itself is 3 &g

Re: Query hitting empty tables taking 48 minutes

> On Jun 18, 2018, at 4:33 PM, Robert Creager wrote: > >> I cannot explain the discrepancy between the runtimes of 85 seconds versus >> 10857 seconds. > > It would be nice if the auto_explain analyze did include the other > information like the psql analyze does.

Re: Not able to update some rows in a table

> I have a table with 21 columns. > Primary key is done with 20 of these colums. Oh, okay. What data types do these encompass? > I don't know why, but I'm not able to update some of these records. > I don't understand, it seems that I'm not able to fetch. You mean you can't query them with all 2

Re: Ways to deal with large amount of columns;

As David said, you'd be better off having a table that looks like this (in terms of columns): * MONTH * AGENT * CASHFLOW So your query to get the sum of a single agent would be looking like: select sum(CHASFLOW) where AGENT = 'Agent' and MONTH between values;

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 9:41 AM, Adrian Klaver wrote: > On 9/14/18 1:31 AM, Chris Travers wrote: >> >> >> >> On Wed, Sep 12, 2018 at 10:53 PM Tom Lane > > wrote: >> >> I wrote: >> > Stephen Frost mailto:sfr...@snowman.net>> >> writes: >> >> We seem to b

Re: Code of Conduct plan

nce will be keenly felt. In practice, therefore, democracy is going to win out. That's both good and bad. It's good because nobody wants a CoC witch-hunt, and it's bad because there's probably some behavior which legitimately deserves censure and will escape it. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: Code of Conduct plan

o move us in that direction remains unclear to me. I can't say I'm very impressed by the way the process has been carried out up to this point; hopefully it will work out for the best all the same. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: How to handle things that change over time?

I"m a big fan of a table / table_history combo. Meaning, if you have a person and that person can have different states that change frequently, you can do something like this: create table people( person_id person_name ) create table people_state_history( person_id references people, effective t

Re: GPS coordinates problem

You can use the postgis extension: create extension postgis; Then you can create a geography coulmn location geography( point, 4326) and insert a lat /long as a point like this: ST_GeographyFromText('SRID=4326;POINT(%(longitude)s %(latitude)s)'), On Tue, Oct 8, 2019 at 1:30 PM Andreas Kret

Postgresql 12.x on Windows (vs Linux)

I am aware that this might be a broad question, but I am not expecting *very *specific answers either: When it come to running a modern PostgreSQL server, which serves say 1 TB of data, are there substantial differences in performance between Windows Server 2019 and Linux today? I know there are

Basic question about structuring SQL

ngs committed even if other things (in tidy-up) fail. So how SHOULD I tackle this? PostgreSQL does not do nested transactions (right?) So how should I structure my chunks of SQL so that I can have "safe" (all-or-nothing) blocks, AND use them from within one another? Robert

RE: PG Admin 4

al Message- From: Adrian Klaver Sent: Friday, July 10, 2020 1:47 PM To: Robert West ; pgsql-gene...@postgresql.org Subject: Re: PG Admin 4 ATTENTION: This email was sent from an external source. Please exercise caution when opening attachments or clicking links. On 7/10/20 8:53 AM, rwest wr

Writing WAL files

hanges. So what am I missing? How CAN I get postgresql 12 to write "unnecessary" WAL files every couple of minutes? Robert. -- Robert Inder,0131 229 1052 / 07808 492 213 Interactive Information Ltd, 3, Lauriston Gardens, Edinburg

Re: Writing WAL files

On Sun, 4 Oct 2020 at 18:01, Adrian Klaver wrote: > On 10/4/20 9:54 AM, Robert Inder wrote: > > I am moving a database from PSQL 9 (!) on CentOS 6 to PSQL 12 on CentOS 7 > > It would help to know what the x in 9.x is? Before version 10 of > Postgres, the second number denot

Re: Writing WAL files

need to > change your configuration so that it uses streaming replication instead > of pg_standby and rsync, but that's far more convenient so it's a good > change anyway.) > Maybe, but it's forcing me to spend time understanding stuff t

Re: Writing WAL files

Indeed. Once upon a time, my signature use to be along the lines of So what? It's easier for me, so I'll do it! > > What's wrong with top posting? > It makes it hard to see comments in context. Robert. -- Robert Inder,0131 2

Re: Christopher Browne

.livejournal.com/obartunov/24248903/36575/36575_original.jpg, he is the one in the back, holding up the sign. Robert Treat https://xzilla.net

ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it

postgresql-client I not enough, as I have the same situation afterwards. Or is there a way that I can rebuild PostgreSQL datastructure? thanks Robert

solved (was plain stupidity) Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it

thanks a lot. why dos such stupidity not hurt. ? have a nice weekend robert On 24.01.21 08:04, Julien Rouhaud wrote: On Sun, Jan 24, 2021 at 2:58 PM rob...@redo2oo.ch wrote: root@elfero-test:~/scripts# pg_lsclusters Ver Cluster Port Status OwnerData directory Log file 10

Re: LwLocks contention

output to see what relations are in play for the queries that are waiting on said lwlocks (especially trying to map write queries to tables/indexes). Robert Treat https://xzilla.net

pg_stat_activity.query empty

When executing "SELECT * FROM pg_stat_activity" I get lots of rows that have an empty "query" column. According to [1] this column should contain the "Text of this backend's most recent query", either a query that is currently running or the last query that was executed. So how comes that a

UUID vs serial and currval('sequence_id')

tactinterests( contactid, interest) VALUES (currval('contact_contactid_seq'),'Fishing') returning currval('contact_contactid_seq'); Which is very nice as it gives us back the contactid. Is it possible to get similar functionality using gen_random_uuid() or uuid-ossp? Thanks Robert

Re: UUID vs serial and currval('sequence_id')

UES( (select thisuuid from thisuuid ),'John', 'Smith') returning (select thisuuid from thisuuid ) ) INSERT INTO contactinterests( contactuuid, interest) VALUES ( (select thisuuid from contactuuid ),'Fishing') returning (select thisuuid from contactuuid ); Robert

Window function?

:33 2022-06-04 09:05:53 Thanks in advance to anyone who can help! Robert

Re: Window function?

On Sat, 4 Jun 2022 at 22:56, Thiemo Kellner wrote: > Hi Robert > > Interesting problem. I need to think about it. > > You need to figure out when Input changes. You can achieve this by using > lead or lag (depending of the sort direction over start) > https://www.postgr

Re: Asking for existence of a GUI frame work similar to Oracle APEX for PostgreSQL

lar alternatives might be more what you are angling towards. Hope that helps. Robert Treat https://xzilla.net

default icu locale for new databases (PG15)

t making a decision today that will make my life worse when upgrading from postgres 15 to 16+? For a database with Swedish collation, which option is "the best"? Or perhaps "the most foolproof"? Best regards, Robert Sjöblom -- Innehållet i detta e-postmeddelande är konfid

Logical Replication Sync Validation

understanding correct? Another idea we've had would be to use CTID to fetch the last row (update/insert) in each table on both sides and compare row content, is this feasible? Is it safe to rely on CTIDs across logical replication? best regards, Robert Sjöblom -- Innehållet i detta

Re: CVE-2019-9193 about COPY FROM/TO PROGRAM

do find it interesting that you can actually remove all superuser roles and/or the superuser bit from all roles (not that I would recommend that to anyone) but that these roles cannot be removed without some serious heavy lifting. Given that, I think I would tend to agree, describing them more consistently as "system roles" is probably warranted. Robert Treat https://xzilla.net https://credativ.com

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

orks well within the rails console. That said, my son liked lua when he was a kid, so yeah, there's lots of options, even if plpgsql on the command line isn't strictly one of them. Robert Treat https://xzilla.net

Re: Seeing high query planning time on Azure Postgres Single Server version 11.

non-longer-supported version of Postgres (v11) and not even the latest release of said EOL version. And if I am not mistaken, "Azure Postgres single server version" is also deprecated, so you should really focus on getting upgraded to something more modern. Robert Treat https://xzilla

Re: Question about PostgreSQL upgrade from version 12 to version 15

also be affected if > you upgrade from one ICU version to another. > > > Joe Conway gave a very good presentation on this topic recently: > https://www.postgresql.eu/events/fosdem2024/schedule/session/5127-collation-challenges-sorting-it-out/ > As a bonus, if you do decide to reindex, you'll also benefit from the index deduplication work that was introduced in v13, which should help reduce disk space and make queries a little faster. Robert Treat https://xzilla.net

Re: PostgreSQL as advanced job queuing system

stgres has as the basis for a queue system. And yeah, I suspect this may become a hot topic again now that Redis is moving away from open source: https://redis.com/blog/redis-adopts-dual-source-available-licensing/ Robert Treat https://xzilla.net

Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE

On Mon, Jul 8, 2024 at 6:08 PM Tom Lane wrote: > >> Hmm, if that check doesn't require INHERIT TRUE I'd say it's > >> a bug. > > > The code doesn't support that claim. > > That doesn't make it not a bug. Robert, what do you think? If

Re: Planet Postgres and the curse of AI

les that will satisfy some of the more legalistic folks among us, this would be a simple warning that would at least encourage folks to make sure they aren't posting bad information and leave a door open for enforcement if needed. And yes, this assumes that the folks running planet will enforce if needed, though I don't think it requires heavy policing at this point. Robert Treat https://xzilla.net

Re: Backward compat issue with v16 around ROLEs

* and undo the reciprocal grants that bob and alice made to each other? Right now I believe we just ask "is the number of sources that alices has for this privilege still greater than zero" which only works if there are no cycles but maybe we can do better. We'd probably need to thin

how to set permission, so I can run pg_dumd in a cron job

Hi Friends I would like to have a cronjob creating a dump of a db. I am on a ubuntu 18 lts, potgres v10. I have a user robert with superuser db permission. a database "mydb" of which I would like to to a nightly dump. I tried to set thing in hba_conf like this: # Database admi

Re: how to set permission, so I can run pg_dumd in a cron job

Adrin, thanks On 13.03.21 17:23, Adrian Klaver wrote: On 3/13/21 8:16 AM, robert rottermann wrote: Hi Friends I would like to have a cronjob creating a dump of a db. I am on a ubuntu 18 lts, potgres v10. I have a user robert with superuser db permission. a database "mydb" of whi

solved: Re: how to set permission, so I can run pg_dumd in a cron job

Thanks again Adrian On 13.03.21 18:37, Adrian Klaver wrote: On 3/13/21 9:25 AM, robert rottermann wrote: Adrin, thanks can you please give me a hand 1) Did you have the server reload the conf files after making the changes? yes I did 2) Is there an entry for something like: local

how to best remove version 10 (and keep version 9.5)

tup is kind of temporary and will be migrated to the “real thing" during this year. So it is not a problem that the PostgreSQL version is dated. I would be grateful for your help robert

Re: impact of version upgrade on fts

upgrade the extension itself to work in the new version of Postgres. Specifics around that will also depend on how you instead to run your upgrade process. Robert Treat https://xzilla.net

Setting a default for nextval sequence

I'm attempting to set the default value for a serial column. I created a generic function that I am passing a table name as the only parameter. I had it working correctly, however, it does not seem to like the sequence name being the same name for each audit table that is created through the func

Setting a serial column with serial object that has a name that is built dynamically

How do I set a serial column with the next value when the serial object has a name that is built dynamically? EXECUTE 'CREATE SEQUENCE '|| *t_name *|| *'id_seq'* || ' OWNED BY '|| t_name || '_cdc'||'.table_id'; EXECUTE 'ALTER TABLE ' || quote_ident(t_name || '_cdc') || ' ALTER COLUMN table_id

Re: ERROR: too many dynamic shared memory segments

t? Why not just avoid creating it in the first place, like this? I haven't checked whether this fixes the bug, but if it does, we can avoid introducing an extra branch in BitmapHeapNext. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company no-pstate.patch Description: Binary data

Re: ERROR: too many dynamic shared memory segments

0 || error_queue_space != NULL); for (i = 0; i < pcxt->nworkers; ++i) { char *start; With that fix in place, I then hit a crash in parallel bitmap heap scan. After applying no-pstate.patch, which I just committed and back-patched to v10, then things look OK. I'm going to apply

Where to troubleshoot phpPgAdmin login issues?

I am getting "Login failed" errors when attempting to log into phpPgAdmin as user 'postgres'. In what file path would I find the relevant log files, to try and identify why the login is being rejected? OS: CentOS 7 PostgreSQL: 9.6.6 pg_hba.conf settings for access: # TYPE DATABASEUSER

Query optimization with repeated calculations

verhead in that and some kind of rule of thumb or general guideline would be helpful as it is a frequent question for me. Thank you! Robert

Information on savepoint requirement within transctions

I'm currently doing a small writeup of a bug fix in our framework which involves savepoints in PostgreSQL (JDBC). However, I have a hard time locating the documentation regarding this. I mean, from what I can extract from various sources, PostgreSQL requires to use savepoints if one wants to contin

Re: Information on savepoint requirement within transctions

BACK TO is the only way to regain control of a transaction block that was put in aborted state by the system due to an error, short of rolling it back completely and starting again. and I'm looking on more information on *that*. On 26.01.2018 15:59, Melvin Davidson wrote: > On Fri, Jan

Re: Information on savepoint requirement within transctions

Melvin Davidson wrote: > On Fri, Jan 26, 2018 at 10:32 AM, Robert Zenz > wrote: > >> Well, no. What I'm looking for is information on how the transactions >> behave in >> an error case, and why there is the requirement to have a savepoint in >> place to >>

Re: Information on savepoint requirement within transctions

On 26.01.2018 17:11, David G. Johnston wrote: > ​The convention for these lists is to inline or bottom-post. Top-posting > is discouraged. Okay, I'll keep it in mind. > Here's my take, the docs support this but maybe take some interpretation... > > A SAVEPOINT ​begins what is effectively a sub-

Fwd: Re: Information on savepoint requirement within transctions

On 29.01.2018 12:37, Adam Tauno Williams wrote: > It this statement true? I very much feel *not*. This depends on how > you have set AUTO_COMMIT - and it certainly is not true for > transactions of multiple statements. Maybe I should clarify at that point that AUTO_COMMIT is OFF, and yes, that i

Re: Information on savepoint requirement within transctions

On 29.01.2018 14:36, David G. Johnston wrote: > ​Those questions would not be answered in user-facing documentation. You > can explore the git history and search the far-back mailing list archives if > you wish to satisfy your curiosity. For me this is how it works - the only > question for me is

Re: Information on savepoint requirement within transctions

On 29.01.2018 15:11, Alban Hertroys wrote: > IMHO, the burden of explaining that is with those RDBMSes that don't > behave properly: > > If you start a transaction and something goes wrong in the process, > the logical behaviour is to fail - the user will want to rollback to a > sane state, doing

Re: Information on savepoint requirement within transctions

On 29.01.2018 16:33, Tom Lane wrote: > That behavior does exist, and so does documentation for it; you're just > looking in the wrong place. > > Years ago (7.3 era, around 2002) we experimented with a server-side > GUC variable "AUTOCOMMIT", which switched from the implicit-commit- > if-you-don't-

Re: Information on savepoint requirement within transctions

On 30.01.2018 03:07, David G. Johnston wrote: > ​So, my first pass at this. Nice, thank you. > + These are of particular use for client software to use when executing > + user-supplied SQL statements and want to provide try/catch behavior > + where failures are ignored. Personally, I'd rewor

Re: Information on savepoint requirement within transctions

On 31.01.2018 19:58, David G. Johnston wrote: > ​Now that I've skimmed the tutorial again I think pointing the reader of > the SQL Commands there to learn how it works in practice is better than > trying to explain it in BEGIN and/or SAVEPOINT. That seems like a good idea, yeah. > I decided to ad

pgadmin4: not possible to create server

t" (127.0.0.1) and accepting TCP/IP connections on port 5432? can anybody give me a hint, what to do? thanks robert in /etc/postgresql/10/main/postgresql.conf i have: #---

Prepared statements (PREPARE and JDBC) are a lot slower than "normal" ones.

We are seeing a quite heavy slow down when using prepared statements in 10.1. I haven't done some thorough testing, to be honest, but what we are having is a select from a view (complexity of it should not matter in my opinion), something like this: prepare TEST (text, int) select * from OUR_

Re: Why no pg_has_role(..., 'ADMIN')?

that you need to have ADMIN OPTION on the role. The rule is: 1. You must have ADMIN OPTION on the target role. 2. You must also have CREATEROLE. 3. If the target role is SUPERUSER, you must be SUPERUSER. If I'm not wrong, pg_has_role(..., 'USAGE WITH ADMIN OPTION') will test #1 for you, but not #2 or #3. -- Robert Haas EDB: http://www.enterprisedb.com

Re: Why no pg_has_role(..., 'ADMIN')?

(all six spellings test the same thing). I don't have an opinion about the details, but +1 for documenting it somehow. I also think it's weird that we have six spellings that test the same thing, none of which are $SUBJECT. pg_has_role seems a little half-baked to

Re: How to perform a long running dry run transaction without blocking

>> Anyway, thanks so much for your help. This discussion has been very useful, >> and I think I will proceed at first, exactly how you suggested, by queuing >> every validation job (using celery). Then I will explore whether or not I >> can apply the "on timeout" strategy in a small patch. >>

Re: How to perform a long running dry run transaction without blocking

for the first time, in preparation for the upcoming publication. This discussion is about the data submission interface, but that interface is actually disabled on the public-facing instance. The other part of the codebase that I was primarily responsible for was the advanced search. Everything else wa

Re: How to perform a long running dry run transaction without blocking

sheet/row/column is related to that error. And it saves me the overhead of having to maintain synchronicity between separate validation code and loading code when the loading code changes. Robert William Leach Research Software Engineer 133 Carl C. Icahn Lab Lewis-Sigler Institute for Integrative Genomics Princeton University Princeton, NJ 08544

Re: How to perform a long running dry run transaction without blocking

>>> The load to the development server does no validation? >>> >>> If so what is the purpose? >>> >>> The background processes are other validation runs? >> It's the same code that executes in both cases (with or without the >> `--validate` flag). All that that flag does is it (effectively) rai

Re: How to perform a long running dry run transaction without blocking

ns to optimize the loading scripts that hopefully could get the largest studies down to a dozen seconds. If I could do that, and do the back end loads in off-peak hours, then I'd be willing to suffer the rare timeouts from concurrent validations. The raw data loads will still likely take a much longer time. Robert William Leach Research Software Engineer 133 Carl C. Icahn Lab Lewis-Sigler Institute for Integrative Genomics Princeton University Princeton, NJ 08544

How to perform a long running dry run transaction without blocking

I've been trying to solve this problem in Django and I've finally decided after over a year going down this path that there's no way to solve it in Django (in a database agnostic fashion). So I'm thinking that I need to explore a Postgres-specific solution. FYI, I'm not a database expert. I just

Re: ZFS filesystem - supported ?

up. Btrfs *definitely* didn't; I was surprised at how badly it performed. -- Robert L Mathews, Tiger Technologies, http://www.tigertech.net/