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
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: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
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
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 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
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 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
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 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
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
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
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
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
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 +0000, Howard News wrote:
Hi,
I uninstalled the wrong version of postgres on Ubuntu using apt-get remove
postg
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.
16 matches
Mail list logo
