Hi,
I've stumbled on pg_dumpall problem:
--
pg_dump: ERROR: could not format inet value: Address family not supported by
protocol
pg_dump: SQL command to dump the contents of table elog failed: PQendcopy()
failed.
pg_dump: Error message from server: ERROR: could not format inet value:
am Wed, dem 05.12.2007, um 10:24:04 + mailte Ashish Karalkar folgendes:
Hello List member,
Iha a table containing two columns x and y . for single value of x there are
multiple values in y e.g
X Y
1 ABC
2 PQR
3 XYZ
4 LMN
1 LMN
2
A. Kretschmer [EMAIL PROTECTED] wrote: am Wed, dem 05.12.2007, um 10:24:04
+ mailte Ashish Karalkar folgendes:
Hello List member,
Iha a table containing two columns x and y . for single value of x there are
multiple values in y e.g
X Y
1 ABC
2 PQR
Hello List member,
Iha a table containing two columns x and y . for single value of x there are
multiple values in y e.g
XY
1ABC
2PQR
3 XYZ
4 LMN
1 LMN
2 XYZ
I want a query that will give me following output
1ABC:LMN
2
I'm sorry,
it was issue with my PITR replication setup which I think I've fixed now.
(race condition between full db backup and pg_dump).
Regards,
Tomas Simonaitis
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your
On Wed, Dec 05, 2007 at 10:24:04AM +, Ashish Karalkar wrote:
Hello List member,
Iha a table containing two columns x and y . for single value of x there are
multiple values in y e.g
XY
1ABC
2PQR
3 XYZ
4 LMN
1 LMN
2
Hi,
Its not elegant, and certainly not dynamic or the perfect solution or for
anything but a static dataset but I've approached this in SQL before as...
First work out the maximum number of times each value of X will occur in the
table - something like select max(subfoo.ycount) from (select
Hello list,
Usually I can see what is wrong with queries but I can't figure out
why this query is slow.
Below is query and explain analyze output.
Any help would be appreciated.
EXPLAIN ANALYZE SELECT computer_name
FROM tbl_computer
INNER JOIN tbl_share ON pk_computer_id =
Hello!
I have a problem joining two tables. I tried various types of join and
none seems to work as I expect
Table 1:
id | stuff
---
1 | sth1
2 | sth2
3 | sth3
4 | sth4
5 | sth5
.. | ...
Table 2:
id | desc | etc
--
1 | desc1 | etc1
2 | desc2 | etc2
On 5 déc. 07, at 14:42, Przemyslaw Bojczuk wrote:
Hello!
I have a problem joining two tables. I tried various types of join and
none seems to work as I expect
Table 1:
id | stuff
---
1 | sth1
2 | sth2
3 | sth3
4 | sth4
5 | sth5
.. | ...
Table 2:
id | desc | etc
am Wed, dem 05.12.2007, um 14:42:32 +0100 mailte Przemyslaw Bojczuk folgendes:
Hello!
I have a problem joining two tables. I tried various types of join and
none seems to work as I expect
Table 1:
id | stuff
---
1 | sth1
2 | sth2
3 | sth3
4 | sth4
5 | sth5
..
On Wednesday 05 December 2007 07:22, Alvaro Herrera wrote:
Robert Treat wrote:
On Monday 03 December 2007 20:22, Erik Jones wrote:
Interesting. If this is anything you'd like to look into I can
provide whatever diagnostic output you need (iostat, vmstat, dtrace
script outputs, etc...)
am Wed, dem 05.12.2007, um 3:46:26 -0800 mailte David Fetter folgendes:
Use the array_accum aggregate from the docs as follows:
SELECT x, array_to_string(array_accum(y),':')
FROM your_table
GROUP BY x;
Yes, no noubt a better solution as my new aggregat...
Andreas
--
Andreas Kretschmer
folks
i've installed 8.3beta but at start up receive
FATAL: invalid value for parameter
timezone_abbreviations: Default
any clue?
best regards.
MDC
info:
Linux richelet-internet 2.6.21.6 #9 SMP Sun Dec 2
17:52:20 ART 2007 i686 Pentium III (Coppermine)
GenuineIntel GNU/Linux
gp_config
Henrik Zagerholm [EMAIL PROTECTED] writes:
Usually I can see what is wrong with queries but I can't figure out
why this query is slow.
Seems the main problem is here:
- Bitmap Index Scan on tbl_archive_idx1
(cost=0.00..1150.47 rows=8 width=0) (actual
Alvaro ,folks
--- Alvaro Herrera [EMAIL PROTECTED] escribió:
marcelo Cortez escribió:
folks
i've installed 8.3beta but at start up receive
FATAL: invalid value for parameter
timezone_abbreviations: Default
Do you have a file named Default on the
share/timezonesets dir?
marcelo Cortez escribió:
folks
i've installed 8.3beta but at start up receive
FATAL: invalid value for parameter
timezone_abbreviations: Default
Wow, strange. Mismatching case, perhaps?
--
Alvaro Herrerahttp://www.advogato.org/person/alvherre
Cuando mañana
Hi,
i'm trying to find out the storage size for bit(n) data. My initial
assumption would be that for any 8 bits, one byte of storage is required.
Is this assumption correct? I didn't find that information in the online
docs.
thanks,
Alex
---(end of
On Dec 5, 2007, at 7:50 AM, Robert Treat wrote:
On Wednesday 05 December 2007 07:22, Alvaro Herrera wrote:
Robert Treat wrote:
On Monday 03 December 2007 20:22, Erik Jones wrote:
Interesting. If this is anything you'd like to look into I can
provide whatever diagnostic output you need
John Wells wrote:
I have pg_filedump installed, but can't figure out how to dump the
rows themselves. I get the equivalent of the output at the end of this
post. Looking over the --help, there's nothing obvious that has gotten
me further.
-i is the option you need; but you have to keep in
On Mon, Dec 03, 2007 at 12:51:27PM -0500,
Josh Harrison [EMAIL PROTECTED] wrote
a message of 63 lines which said:
The encoding you selected (UTF8) and the encoding that the
selected locale uses (LATIN1) do not match.
Indeed.
Rerun initdb and either do not specify an encoding explicitly,
On Wed, Dec 05, 2007 at 12:53:45AM -0500, Greg Smith wrote:
The issue Andrew is bringing up here is that really new PostgreSQL
versions probably aren't necessairly backward compatible talking to or
reading dumps from your 7.0 system, so your odds are better trying to
upgrade to 7.3 instead
On Dec 5, 2007, at 1:39 PM, SHARMILA JOTHIRAJAH wrote:
This basically archives the data in the primary server
itself...right!!!
But how can I set up continuous archiving from primary to a
directory
(WAL archive directory) on the stand-by server ?
The closest thing to a worked out
This basically archives the data in the primary server
itself...right!!!
But how can I set up continuous archiving from primary to a directory
(WAL archive directory) on the stand-by server ?
The closest thing to a worked out example of how to do this I'm aware
of
is at
I've to fill something like:
create table DESTtable1 (
pk1 serial primary key,
-- rest of stuff
);
create table DESTtable2 (
pk2 serial primary key,
fk1 int references DESTtable1(pk1)
-- rest of stuff
);
from data that are such way
create table SRCtable1 (
pk1 serial primary key,
--
marcelo Cortez escribió:
folks
i've installed 8.3beta but at start up receive
FATAL: invalid value for parameter
timezone_abbreviations: Default
Do you have a file named Default on the share/timezonesets dir?
I'm wondering if your installation is being mistakenly trying to use a
On Monday 03 December 2007 17:32, Erik Jones wrote:
Hi, I've inherited smirk a database schema wherein the original
developers took the inheritance mechanism to an extreme where new
client accounts get 13 different tables of their own created for
them. We're at the many tens of thousands of
On Dec 5, 2007, at 7:50 AM, Robert Treat wrote:
On Wednesday 05 December 2007 07:22, Alvaro Herrera wrote:
Robert Treat wrote:
On Monday 03 December 2007 20:22, Erik Jones wrote:
Interesting. If this is anything you'd like to look into I can
provide whatever diagnostic output you need
When we run pg_dump on our database, our web site becomes completely
unresponsive. I thought pg_dump was runnable while the database was
still being actively used? Anyway, I'm not entirely sure why, but
here's what I'm seeing.
pg_dump -v database_name | gzip output_file
25% to 50% CPU usage (4
Rober,
Thank you once again for your input.
On Dec 5, 2007, at 3:23 PM, Robert Treat wrote:
On Monday 03 December 2007 17:32, Erik Jones wrote:
snip Too much to keep quoted here. Check the archives if you want
to read more about the setup for this conversation.
-[ RECORD 1
John Wells wrote:
On 12/5/07, Alvaro Herrera [EMAIL PROTECTED] wrote:
John Wells wrote:
I have pg_filedump installed, but can't figure out how to dump the
rows themselves. I get the equivalent of the output at the end of this
post. Looking over the --help, there's nothing obvious
5 dec 2007 kl. 16.25 skrev Tom Lane:
Henrik Zagerholm [EMAIL PROTECTED] writes:
Usually I can see what is wrong with queries but I can't figure out
why this query is slow.
Seems the main problem is here:
- Bitmap Index Scan on tbl_archive_idx1
(cost=0.00..1150.47
I've to fill something like:
create table DESTtable1 (
pk1 serial primary key,
-- rest of stuff
);
create table DESTtable2 (
pk2 serial primary key,
fk1 int references DESTtable1(pk1)
-- rest of stuff
);
from data that are such way
create table SRCtable1 (
pk1 serial primary key,
--
Bryan Murphy wrote:
When we run pg_dump on our database, our web site becomes completely
unresponsive. I thought pg_dump was runnable while the database was
still being actively used?
It is but it assumes you have resources available.
Anyway, I'm not entirely sure why, but
here's what I'm
Am Montag, 3. Dezember 2007 schrieb Josh Harrison:
initdb -E UTF8 -D /export/home/josh/postgres8.3/pgsql/data
The database cluster will be initialized with locales
COLLATE: en_CA.ISO8859-1
CTYPE:en_CA.ISO8859-1
MESSAGES: C
MONETARY: en_CA.ISO8859-1
NUMERIC: en_CA.ISO8859-1
Alvaro Herrera [EMAIL PROTECTED] writes:
But then I thought, why do we need it to be a file
at all? Why not use a mmap'ed memory area or something like that, and
only write it to a file on postmaster shutdown?
Yeah, we definitely need some other technology for this. The difficulty
is in
On Wed, Dec 05, 2007 at 11:43:08AM +,
Steve Grey [EMAIL PROTECTED] wrote
a message of 153 lines which said:
First work out the maximum number of times each value of X will occur in the
table
A better solution, when you do not know this maximum number, is CREATE
AGGREGATE
On 12/4/07, Martijn van Oosterhout [EMAIL PROTECTED] wrote:
On Tue, Dec 04, 2007 at 03:05:53PM -0500, John Wells wrote:
So, given a database table file that still has records in it, and
given the fact that these records could be parsed and displayed if the
proper utilty knew how to read the
Sorry about the formatting, here's the dump as a text file.
Thanks,
Bryan
On Dec 5, 2007 10:05 AM, Bryan Murphy [EMAIL PROTECTED] wrote:
When we run pg_dump on our database, our web site becomes completely
unresponsive. I thought pg_dump was runnable while the database was
still being
Robert Treat wrote:
On Monday 03 December 2007 20:22, Erik Jones wrote:
Interesting. If this is anything you'd like to look into I can
provide whatever diagnostic output you need (iostat, vmstat, dtrace
script outputs, etc...) but I do have to reiterate that we are an
extreme corner
Thomas Burdairon wrote:
hope this help.
Thank you, it helped a lot! It was a part of a bigger problem
(involving PostGIS, Mapserver et al.) and I *thought* I traced it down
to this join, but now it's clear the problem lies completely elsewhere.
Thanks again!
PB
--
Geographical Information
On 11/29/07, Stefan Niantschur [EMAIL PROTECTED] wrote:
SELECT
pgp_pub_decrypt(dearmor(armor(pgp_pub_encrypt(armor(pgp_sym_encrypt('geheim'::text,'test'::text)),dearmor((SELECT
ens_pubkey FROM ens_user WHERE ens_userid =
10112)::text,dearmor((SELECT ens_privkey FROM ens_user WHERE
Hi,
I'd like to ask if there is a version of pgAccess that works with
PostgreSQL 8.2.5 for CentOS 4, RHEL4 or SL4 which allows creating and
editing tables in GUI?
Thank you.
Kandy
---(end of broadcast)---
TIP 9: In versions below 8.0, the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 05 Dec 2007 16:50:27 -0800
Kandy Wong [EMAIL PROTECTED] wrote:
Hi,
I'd like to ask if there is a version of pgAccess that works with
PostgreSQL 8.2.5 for CentOS 4, RHEL4 or SL4 which allows creating and
editing tables in GUI?
On Dec 5, 2007 10:14 AM, Joshua D. Drake [EMAIL PROTECTED] wrote:
Pg_dump uses Access Share if I recall. You can operate normally while
running pg_dump. I am having a hard time parsing that. Could you instead
go over to pgsql.privatepaste.com and send back a paste link?
Am Montag, 3. Dezember 2007 schrieb Josh Harrison:
initdb -E en_CA.utf-8 -D /export/home/sjothirajah/postgres8.3/pgsql/data
gives this error
initdb: en_CA.utf-8 is not a valid server encoding name
The option name you want is --locale, not -E.
--
Peter Eisentraut
On Dec 5, 2007, at 14:19 , Alex Mayrhofer wrote:
Hi,
i'm trying to find out the storage size for bit(n) data. My initial
assumption would be that for any 8 bits, one byte of storage is
required.
select pg_column_size(B'1') as 1bit,
pg_column_size(B'') as 4bits,
Hi,
the docs for Full Text Search (pre 8.3: tsearch2) explain how to include
a thesaurus dictionary. It also says the current implementation is
only an extension of the synonym dictionary with added phrase support.
Are there any plans to include a proper thesaurs support, with broader
terms
On 05/12/2007, Keaton Adams [EMAIL PROTECTED] wrote:
We're running PostgreSQL 8.1.4 on RHEL. I'm running a vacuum analyze on
the mxl_fs_size table to see if that shows anything.
-Keaton
On 12/4/07 10:50 PM, Keaton Adams [EMAIL PROTECTED] wrote:
We have two servers configured the same
On Saturday 1 December 2007 David Fetter's cat, walking on the keyboard,
wrote:
You'd only think so if you hadn't actually seen these things in
action. They save no time because of the silly, unreasonable
assumptions underlying them, which in turn cause people to do silly,
unreasonable
Thank you for your reply
but I got the error 'LC_MESSAGES' : undeclared identifier
locale.h only defines LC_COLLATE, LC_CTYPE, LC_MONETARY, LC_NUMERIC, LC_TIME
I tried to set a system variable LC_MESSAGES, but didn't work
Then, I tried to find more information
In libpq, when ENABLE_NLS is
On Wed, 5 Dec 2007, SHARMILA JOTHIRAJAH wrote:
I see the archive directory in standby server getting filled up, but
there are no log messages generated. Whay? What am I missing here?
If you're using pg_standby, you can pass it -d to have it log more
information about what's going on, which
Where can I find information on when support for 7.4.x formally cease?
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 0415 469 095
www.flashdev.org.au
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Bryan Murphy [EMAIL PROTECTED] writes:
When we run pg_dump on our database, our web site becomes completely
unresponsive. ...
Does pg_dump create table locks? It doesn't look like an I/O problem
as far as I can tell...
Only access-share locks, but that could still be an issue if anything in
Chris Velevitch wrote:
Where can I find information on when support for 7.4.x formally cease?
This has yet to be determined. However you can expect that it will be
considered in the next 12 to 18 months. We are about to EOL 7.3.
Sincerely,
Joshua D. Drake
Chris
Ivan Sergio Borgonovo [EMAIL PROTECTED] writes:
... BTW I saw there is no OWNED BY in 8.1, is there any other way to
auto-drop sequences when columns get dropped?
In previous versions, a sequence object that was auto-created as a
result of a SERIAL column declaration will be auto-dropped when
56 matches
Mail list logo