Ralf Schuchardt wrote:
Am 19.Dez. 2013 um 09:41 schrieb Andreas Kretschmer andr...@a-kretschmer.de:
don't ask why, but a customer created tables with foreign key constraints but
with inconsistent data.
Because of this he disabled all triggers (alter table foo disable trigger
all).
So far,
On 12/20/2013 01:01 AM, Michael Paquier wrote:
You should go with pg_dump if you are able to get a clean dump. Such
block errors happen because of hardware issues, so you are not safe
from additional failures that might happen while you do a copy of the
existing data folder to a new system.
I
Hi ,
please let me know how I can connect postgresql using squirrel sql client
3.4.0.
Thanks Regards
Arindam Mondal
Hi Michael,
Sorry about that.
Anyway, my colleague just sent out a similar question to this mailing list
right after I sent mine. The subject title is pg_upgrade tablespaces.
If you can help us from my colleague's email, I really appreciate.
Thanks!
-Laurent
On Fri, Dec 20, 2013 at 1:05 AM,
On 12/20/2013 01:08 AM, Arindam Mondal wrote:
Hi ,
please let me know how I can connect postgresql using squirrel sql
client 3.4.0.
Make sure you have the Postgres JDBC driver:
http://jdbc.postgresql.org/download.html
Configure SQuirrel:
On Thu, Dec 19, 2013 at 6:19 PM, Adrian Klaver adrian.kla...@gmail.comwrote:
On 12/19/2013 01:50 PM, Joseph Kregloh wrote:
On Thu, Dec 19, 2013 at 4:14 PM, John R Pierce pie...@hogranch.com
mailto:pie...@hogranch.com wrote:
On 12/19/2013 1:06 PM, Joseph Kregloh wrote:
It's
On 12/20/2013 06:54 AM, Joseph Kregloh wrote:
On Thu, Dec 19, 2013 at 6:19 PM, Adrian Klaver adrian.kla...@gmail.com
mailto:adrian.kla...@gmail.com wrote:
On 12/19/2013 01:50 PM, Joseph Kregloh wrote:
On Thu, Dec 19, 2013 at 4:14 PM, John R Pierce
pie...@hogranch.com
On Fri, Dec 20, 2013 at 10:26 AM, Adrian Klaver adrian.kla...@gmail.comwrote:
On 12/20/2013 06:54 AM, Joseph Kregloh wrote:
On Thu, Dec 19, 2013 at 6:19 PM, Adrian Klaver adrian.kla...@gmail.com
mailto:adrian.kla...@gmail.com wrote:
On 12/19/2013 01:50 PM, Joseph Kregloh wrote:
On 12/20/2013 07:32 AM, Joseph Kregloh wrote:
Case B:
pg_upgrade -b /home/jkregloh/pg_bin/ -B /usr/local/bin/ -D
/usr/local/pgsql_93/data -d /usr/local/pgsql/data/ -P 5452 -p 5451
In this case, the OLD cluster is in the default location and the
new one
Currently the documentation looks like:
client_min_messages (enum)
Controls which message levels are sent to the client. Valid values are
DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, LOG, NOTICE, WARNING, ERROR, FATAL,
and PANIC. Each level includes all the levels that follow it. The later the
level,
2013/12/20 Adrian Klaver adrian.kla...@gmail.com:
On 12/20/2013 01:08 AM, Arindam Mondal wrote:
Hi ,
please let me know how I can connect postgresql using squirrel sql
client 3.4.0.
Make sure you have the Postgres JDBC driver:
http://jdbc.postgresql.org/download.html
Configure
On Thu, Dec 19, 2013 at 12:49 PM, Joseph Kregloh jkreg...@sproutloud.comwrote:
[pgsql@postgres-93-upgrade ~]$ ls -l
/home/jkregloh/pg_data/data/pg_tblspc/
lrwxr-xr-x 1 pgsql pgsql41 Dec 19 19:53 11047389 -
/home/jkregloh/pg_data/data/stats_dbspace
lrwxr-xr-x 1 pgsql pgsql
So was your latest attempt where you ended up with a doubled data/ in the
two or one jail scenario?
The two jails scenario. The two jail scenario is the same as the mounted
scenario.
Can we see a directory listing for that case?
You say in the single jail case you got the same results.
Thank you. pg_dump is what we will use.
We did re-assign the LUN to a new system last night, and are monitoring.
Too early to say anything, but so far, we haven't seen the corruption.
And yes, we will get the dump from the new system.
We do not have the hardware to move the backups to a
On 12/20/2013 10:42 AM, Joseph Kregloh wrote:
So was your latest attempt where you ended up with a doubled data/
in the two or one jail scenario?
The two jails scenario. The two jail scenario is the same as the mounted
scenario.
Can we see a directory listing for that case?
Hi,
assuming I have a query that computes a running sum like this:
select id, buy_price, sum(buy_price) over (order by id) sum
from fmb
where 202300=id and id=202400
order by id;
Do I need the ORDER BY clause at the end? Or does the ORDER BY in the
window function already define the
Torsten Förtsch wrote
Hi,
assuming I have a query that computes a running sum like this:
select id, buy_price, sum(buy_price) over (order by id) sum
from fmb
where 202300=id and id=202400
order by id;
Do I need the ORDER BY clause at the end? Or does the ORDER BY in the
HI,
I am working on Postgresql 9.1.3.
I executed the following query and got an error:
select relname, pg_size_pretty(pg_table_size(relname::text)) as s from
pg_stat_user_tables order by pg_table_size(relname::text) desc limit 10;
ERROR: relation tab_20130206 does not exist
That table does
=?ISO-8859-1?Q?Torsten_F=F6rtsch?= torsten.foert...@gmx.net writes:
select id, buy_price, sum(buy_price) over (order by id) sum
from fmb
where 202300=id and id=202400
order by id;
Do I need the ORDER BY clause at the end? Or does the ORDER BY in the
window function already
AI Rumman rumman...@gmail.com writes:
I executed the following query and got an error:
select relname, pg_size_pretty(pg_table_size(relname::text)) as s from
pg_stat_user_tables order by pg_table_size(relname::text) desc limit 10;
ERROR: relation tab_20130206 does not exist
Use the OID,
On 12/20/2013 02:01 PM, Joseph Kregloh wrote:
[root@postgres-93-upgrade
/usr/local/pgsql/data/drupal___dbspace]# ls -la
/home/jkregloh/pg_data/data/__drupal_dbspace/
drwx-- 4 pgsql pgsql 4 Oct 20 2011 PG_9.0_201008051
So that looks like it worked,
rummandba wrote
HI,
I am working on Postgresql 9.1.3.
I executed the following query and got an error:
select relname, pg_size_pretty(pg_table_size(relname::text)) as s from
pg_stat_user_tables order by pg_table_size(relname::text) desc limit 10;
ERROR: relation tab_20130206 does not
# select to_json(now());
to_json
-
2013-12-20 15:53:39.098204-08
(1 row)
I'd like to see it output 2013-12-20T15:53:39.098204-08 so it's
interchangeable with more systems.
David Johnston wrote
Or feel free to peruse the release notes for 9.2, this behavior change
should be documented if intentional.
Reading said notes it appears that the returns NULL behavior compensates
for a concurrent DROP of an existing/known OID. Since your issue is that
the object was
On Fri, Dec 20, 2013 at 4:18 PM, Joe Van Dyk j...@tanga.com wrote:
# select to_json(now());
to_json
-
2013-12-20 15:53:39.098204-08
(1 row)
I'd like to see it output 2013-12-20T15:53:39.098204-08 so it's
interchangeable with more systems.
On 12/20/2013 02:01 PM, Joseph Kregloh wrote:
Ah, nothing like taking the dog for walk to clear the mind. Led to a
thought. To amend my previous post, instead of using the 9.0 cluster you
have been using, why not create a minimal test cluster? In the crawl,
walk, run vein, start with a
On 12/20/2013 4:14 PM, Adrian Klaver wrote:
Personally I would say at this point the relationships between
versions are so confused it would seem best to start from scratch.
the 80 tablespaces aren't helping this one bit.
I am really curious what lead to creating that many tablespaces?
On Fri, Dec 20, 2013 at 4:24 PM, Joe Van Dyk j...@tanga.com wrote:
On Fri, Dec 20, 2013 at 4:18 PM, Joe Van Dyk j...@tanga.com wrote:
# select to_json(now());
to_json
-
2013-12-20 15:53:39.098204-08
(1 row)
I'd like to see it output
On Thu, Dec 19, 2013 at 11:56 PM, bricklen brick...@gmail.com wrote:
On Thu, Dec 19, 2013 at 1:27 AM, wd w...@wdicc.com wrote:
On Thu, Dec 19, 2013 at 2:24 PM, Amit Langote amitlangot...@gmail.comwrote:
unexpected pageaddr log entry in this case means the standby reached
the end of
On 21/12/13 15:27, Joe Van Dyk wrote:
On Fri, Dec 20, 2013 at 4:24 PM, Joe Van Dyk j...@tanga.com
mailto:j...@tanga.com wrote:
On Fri, Dec 20, 2013 at 4:18 PM, Joe Van Dyk j...@tanga.com
mailto:j...@tanga.com wrote:
# select to_json(now());
to_json
30 matches
Mail list logo