Are there rules for thumb for deciding when you can dump a whole database and
when you’d be better off dumping groups of tables? I have a database that has
around 100 tables, some of them quite large, and right now the data directory
is well over 100GB. My hunch is that I should divide and
December 5, 2017 at 3:59 PM
To: Martin Mueller <martinmuel...@northwestern.edu>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: a back up question
On Tue, Dec 5, 2017 at 2:52 PM, Martin Mueller
<martinmuel...@northwestern.edu<m
value.
Is there a way of doing this in a single-step procedure or can you chain the
two parts together in one query? This goes beyond my SQL competence.
Martin Mueller
I made a stupid mistake with a backup and would be grateful for some advice on
how to extricate myself.
I created a dumpfile from a 10.3 postgres installation on a Mac and tried to
restore it on another Mac 1,000 miles away, but forgot that that machine runs
Postgres 9.6.
The command
Many thanks for your generous help, and on a Sunday afternoon as well.
This is a wonderful listserv, and I am deeply indebted to it.
MM
On 7/15/18, 2:17 PM, "Tom Lane" wrote:
Martin Mueller writes:
> I created a dumpfile from a 10.3 postgres installation on a
not progressed much beyond
8th grade math.
From: "David G. Johnston" <david.g.johns...@gmail.com>
Date: Wednesday, March 7, 2018 at 11:43 AM
To: Martin Mueller <martinmuel...@northwestern.edu>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
there.
From: "David G. Johnston" <david.g.johns...@gmail.com>
Date: Wednesday, March 7, 2018 at 11:23 AM
To: Martin Mueller <martinmuel...@northwestern.edu>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: a very primitive
I have used Aqua Data Studio for several years. Jetbrains recently released a
similar product. Academic licensing is affordable (~ $200 a year) and very
cheap if considered in terms of the time it saves you.
From: David Gauthier
Date: Tuesday, October 30, 2018 at 2:06 PM
To:
I’ve looked at the documentation to find where to find some data that are very
to find Mysql: the creation and modification data of a table and the size of
particular tables.
Where do I find an answer to the question “which is the last table I created”
or “when did I last modify this table?”
I take the point that two decades of backward compatibility should and will
win. That said, it's an easy enough thing to right the balance for novices and
put in a really obvious place in the documentation what you should do if you
want to divide two integers and get the results with the
w the root form, the dictionary was
no use.
In this, single stop shopping for the three most common problems of simple
division makes life easier for users.
On 12/4/18, 3:06 PM, "David G. Johnston" wrote:
On Tue, Dec 4, 2018 at 1:57 PM Martin Mueller
wrote:
>
I didn't formulate my question properly, because the query went like
"select alldefects /wordcount"
where alldefects and wordcount are integers. But none of the different ways
of putting the double colon seemed to work.
The Postgres notation of this simple procedure is very unintuitive. I
On 9/14/18, 12:50 PM, "Joshua D. Drake" wrote:
On 09/14/2018 07:41 AM, James Keener wrote:
> > Community is people who joined it
>
> We're not a "community."
I do not think you are going to get very many people on board with that
argument. As anyone who knows me
What counts as foul language has changed a great deal in the last two decades.
You could always tie it to what is printable in the New York Times, but that
too is changing. I could live with something like “Be considerate, and if you
can’t be nice, be at least civil”.
From: Melvin Davidson
again "Where is the problem that needs solving?"
On 9/15/18, 11:32 AM, "Bruce Momjian" wrote:
On Sat, Sep 15, 2018 at 04:24:38PM +, Martin Mueller wrote:
> What counts as foul language has changed a great deal in the last two
decades.
> You c
As long as subscribers to the list or attendants at a conference do not violate
explicit or implicit house rules, what business does Postgres have worrying
about what they do or say elsewhere? Some version of an 'all-of-life' clause
may be appropriate to the Marines or federal judges, but it
I have followed this list for a couple of years, have benefited several times
from quick and helpful advice, and wonder whether all this code of conduct
stuff is a solution in search of a problem. Or, if there is a problem now and
then, whether an elaborate code does a better job than
, 8:04 PM, "Adrian Klaver" wrote:
On 2/26/19 5:51 PM, Martin Mueller wrote:
> I run Postgres 10.5. I understand that there is something called
> tablefunc and it includes a crosstab function. On Stack Overflow I learn
> that you import this function. But
EXTENSION IF NOT EXISTS tablefunc;
but it did nothing. It doesn’t seem to work as import statements in Python do
-
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
I created a primary key with the following commands
Add id serial
Add primary key (id)
I cannot figure out from the documentation how to drop that column.
table. Which is
really useful if you have a bad memory, as I do, and can't remember the name of
a particular table that I worked on last Wednesday.
Are those capabilities hidden somewhere in Postgres? There isn't an obvious
section in the documentation. At least I can't find it.
Martin Mueller
Leaving aside the question of money, a frontend like AquaData Studio or the
equivalent program by Jetbrains would be a much better solution. I used to work
with Access a lot and quite liked it. But AquaData Studio is not any more
difficult to learn and gives you access to everything Postgress
On the topic of what other databases do better: I much prefer Postgres to Mysql
because it has better string functions and better as well as very courteous
error messages. But MySQL has one feature that sometimes makes me want to
return it: it stores the most important metadata about tables in
Are there performance issues with the choice of 'text' vs. varchar and some
character limit? For instance, if I have a table with ten million records and
text fields that may range in length from 15 to 150, can I expect a measurable
improvement in response time for using varchar(150) or will
is that mapping and how can I query it? On what page of the
documentation do I find the answer?
I much prefer Postgres to Mysql for a variety of reasons, but mostly for its
elegant string functions. But in Mysql it seems to be much easier to keep track
of tables.
Martin Mueller
Professor emeritus
the data via Aqua Data Studio, as if they were very large spreadsheets.
Is that a correct analysis? I just want to make sure.
Martin Mueller
Professor emeritus of English and Classsics
Northwestern University
ment, which handles up to 10 million rows quite
comfortably.
A I right in thinking that given my tasks and equipment it would be a waste of
time to update? Or is there something I’m missing?
Martin Mueller
Professor emeritus of English and Classiccs
Northwestern University
I have a very stupid password question. I don’t know whether a postgres
database on my Mac has a pass word or not.
I access the database via the Aqua Data Studio frontend as the user postgres. I
don’t think I ever added a password, and on the authentication panel the
password box is empty but
I currently work with Postgres 13. I forgot to mention that. From which I
gather that around version 18 it would be time to upgrade. But in the interim
I’d be OK.
Right?
From: Adrian Klaver
Date: Thursday, May 18, 2023 at 11:21 PM
To: Martin Mueller ,
pgsql-general@lists.postgresql.org
29 matches
Mail list logo