Is there an option for psql to use the entry in Comments for "pretty"
column headings in a report? For example, instead of printing the
column name of "last" in the heading, the option would print "Last
Name" that is contained in the Comments field.
The only two alternatives I've found so far
Hi,
Been trying to download the latest ODBC driver for two days now but keep
getting max connection rejects.
Alternatives?
Thanks, -km
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi all,
I have a raid catastrophe which has effectively blitzed a cluster data
directory. I have several pg_dump backups but these will not restore
cleanly. I assume the disk has been failing for some time and the
backups are of the corrupted database.
Using a selective pg_restore on the du
On 07/11/2016 13:12, Albe Laurenz wrote:
Howard News wrote:
I have a raid catastrophe which has effectively blitzed a cluster data
directory. I have several pg_dump backups but these will not restore
cleanly. I assume the disk has been failing for some time and the
backups are of the
On 07/11/2016 13:44, Vick Khera wrote:
On Mon, Nov 7, 2016 at 8:23 AM, Howard News wrote:
pg_restore: executing SEQUENCE SET example_seq
pg_restore: processing data for table example_table
pg_restore: [compress_io]
** crash **
What crashes? the pg_restore process or the backend server
On 08/11/2016 03:27, kaustubh kelkar wrote:
Hi ,
I am a PostgreSQL user who wants to create multiple instances of
PostgreSQL database server. I am using PostgreSQL 9.4 and above.
I tried to create more than 2 instances on Linux environment in which
I was successful. But, for windows environ
Hi,
recently I had problems with a corrupt pg_dump file. The problem with
the file was due to a faulty disk. The trouble with this is that I was
unaware of the disk problem and the pg_dump file corruption so I did not
have a full valid backup. In order to reduce the chances of this I was
hopi
On 30/11/2016 12:27, Karsten Hilbert wrote:
You can try to suitably combine "pg_dump --format=plain" with
"tee" and "md5sum" such that the output stream is diverted to
both a file and a pipe-into-CRC-algorithm and eventually
compare the pipe's sum with the sum generated from the file.
But the
On 30/11/2016 13:05, basti wrote:
My question is. what does send so much traffic on an idle connection
within an hour?
Presumably they are only idle at the point you are viewing the
connections. In my typical usage, the connections are in a connection
pool and are mostly idle. Monitored ove
Regarding the filesystem solution, the dump is currently written to a HP
RAID 10 array with an NTFS partition. What filesystems / raid arrays have
this ability?
If you can't trust your RAID 10 (1 meaning mirrored) to
actually store what you told it to you've got problems beyond
somehow verifying
On 30/11/2016 13:42, Timoteo Blanco wrote:
Howdy,
I've a series of timestamp columns I'd like to alias in select
statements. psql indicates my alias doesnt exist after
I define it.
Example -> select to_char(impressions_create_date,'-mm-dd') as ymd
from impressionsdb where ymd like '201
Hi,
I uninstalled the wrong version of postgres on Ubuntu using apt-get
remove postgresql-9.0, convinced that this was an old unused version.
You guess the rest...
The data files still appear to be there, all 485GB of them. Can these be
restored?
Thanks.
else, simply reinstalling the
package should restore your cluster. Debian packages only do
initialization if the data directories are missing.
David
On Thu, Mar 24, 2016 at 05:29:23PM +, Howard News wrote:
Hi,
I uninstalled the wrong version of postgres on Ubuntu using apt-get remove
postg
On 24/03/2016 17:52, David Wilson wrote:
Per the heading printed by dpkg --list, this means the package is in
the removed state, but it's config files are still present. "apt-get
install postgresql-9.0" should be all required. David
David,
I owe you a beer. Nay - several drinks of your choi
Hi,
I uninstalled the wrong version of postgres on Ubuntu using apt-get
remove postgresql-9.0, convinced that this was an old unused version.
You guess the rest...
The data files still appear to be there, all 485GB of them. Can these be
restored?
Thanks.
--
Sent via pgsql-general mailing
Hi,
does anyone have any pointers for shrinking tsvectors
I have looked at the contents of some of these fields and they contain
many details that are not needed. For example...
"'+1':935,942 '-0500':72 '-0578':932 '-0667':938 '-266':937 '-873':944
'-9972':945 '/partners/application.html':22
On 05/04/2016 14:44, Oleg Bartunov wrote:
On Tue, Apr 5, 2016 at 2:37 PM, Howard News <mailto:howardn...@selestial.com>> wrote:
Hi,
does anyone have any pointers for shrinking tsvectors
I have looked at the contents of some of these fields and they
contain man
On 05/04/2016 15:15, Artur Zakirov wrote:
On 05.04.2016 14:37, Howard News wrote:
Hi,
does anyone have any pointers for shrinking tsvectors
I have looked at the contents of some of these fields and they contain
many details that are not needed. For example...
"'+1':935
Tue, 29 Jan 2013 20:41:58 -0800 (PST)
29 Jan 2013 20:41:58 -0800 (PST)
X-Newsgroups: pgsql.general
Date: Tue, 29 Jan 2013 20:41:57 -0800 (PST)
In-Reply-To:
Complaints-To: groups-ab...@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=76.167.116.131;
posting-acco
Mon, 04 Mar 2013 19:15:32 -0800 (PST)
04 Mar 2013 19:15:32 -0800 (PST)
X-Newsgroups: pgsql.general
Date: Mon, 4 Mar 2013 19:15:31 -0800 (PST)
Complaints-To: groups-ab...@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=76.87.68.198;
posting-account=96NFGAoAAABqg
Sat, 23 Mar 2013 07:13:47 -0700 (PDT)
23 Mar 2013 07:13:47 -0700 (PDT)
X-Newsgroups: pgsql.general
Date: Sat, 23 Mar 2013 07:13:47 -0700 (PDT)
Complaints-To: groups-ab...@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=79.173.238.135;
posting-account=olGTqwoAAA
Wed, 10 Apr 2013 13:30:52 -0700 (PDT)
Wed, 10 Apr 2013 13:30:52 -0700 (PDT)
X-Newsgroups: pgsql.general
Date: Wed, 10 Apr 2013 13:30:52 -0700 (PDT)
Complaints-To: groups-ab...@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=76.87.68.198;
posting-account=96NFGAo
Tue, 09 Apr 2013 04:23:04 -0700 (PDT)
Apr 2013 04:23:04 -0700 (PDT)
X-Newsgroups: pgsql.general
Date: Tue, 9 Apr 2013 04:23:03 -0700 (PDT)
In-Reply-To: <47408590-a31c-4541-a2e4-1da06bb7c...@googlegroups.com>
Complaints-To: groups-ab...@google.com
Injection-Info: glegroupsg2000goo.googlegro
Tue, 09 Apr 2013 04:21:51 -0700 (PDT)
09 Apr 2013 04:21:50 -0700 (PDT)
X-Newsgroups: pgsql.general
Date: Tue, 9 Apr 2013 04:21:50 -0700 (PDT)
Complaints-To: groups-ab...@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=210.143.35.31;
posting-account=GbL1LQo5
Tue, 18 Dec 2012 15:15:41 -0800 (PST)
Received: by 10.50.5.174 with SMTP id t14mr1993997igt.11.1355872541437; Tue,
18 Dec 2012 15:15:41 -0800 (PST)
X-Newsgroups: pgsql.general
Date: Tue, 18 Dec 2012 15:15:41 -0800 (PST)
Complaints-To: groups-ab...@google.com
Injection-Info: glegroupsg2000g
Wed, 19 Dec 2012 00:03:43 -0800 (PST)
Received: by 10.49.127.198 with SMTP id ni6mr757036qeb.23.1355904223562; Wed,
19 Dec 2012 00:03:43 -0800 (PST)
X-Newsgroups: pgsql.general
Date: Wed, 19 Dec 2012 00:03:43 -0800 (PST)
Complaints-To: groups-ab...@google.com
Injection-Info: glegroupsg2000
Sun, 23 Dec 2012 18:45:11 -0800 (PST)
Received: by 10.49.34.135 with SMTP id z7mr3027069qei.1.135631781; Sun, 23
Dec 2012 18:45:11 -0800 (PST)
X-Newsgroups: pgsql.general
Date: Sun, 23 Dec 2012 18:45:11 -0800 (PST)
In-Reply-To:
Complaints-To: groups-ab...@google.com
Injection-Info: gl
Hi!
I've got problem with dumping the database on the slave server.
Situation:
Master:
Running CentOS release 4.4 (Final) with PostgreSQL 8.2.4.
Slave:
Running CentOS release 4.3 (Final) with PostgreSQL 8.2.4 and slon
version 1.2.9
pg_dump on master works fine. On slave i've got error on st
Hi.
There should exist a news-server at:
news://news.postgresql.org/
but I can't connect to it.
It seems does it does not exist.
Even the name can't get resolved.
Is there a new one out there or isn't there one now ?
Cu,
Andreas
PS:
Btw, it got the news-servr from
http://www
Hi,
How do I call a StoredProcdure, written in PlPqSql
which returns a set of records (or tableWhatever)
and wants parameters,
from ADO while using "adCmdStoredProc" ?
ERROR: set-valued function called in context that cannot accept a set
-- VERY LONG VERSION OF THIS QUEST
>>Von: Duffner
> Von: Shachar Shemesh
> Betreff: Re: [GENERAL] ADO adCmdStoredProc PlPgSql-SP Parameters
> >How do I call a StoredProcdure, written in PlPqSql
> >which returns a set of records (or tableWhatever)
> >and wants parameters,
> >from ADO while using "adCmdStoredProc" ?
> Which driver a
33 matches
Mail list logo
