chris.el...@shropshire.gov.uk wrote:
Scott Marlowe wrote on 31/03/2009 15:53:34:
> On Tue, Mar 31, 2009 at 8:21 AM, wrote:
> >
> > Scott Marlowe wrote on 31/03/2009 15:16:01:
> >
> >> I'd call IBM and ask them to come pick up their boat anchors.
> >
> > My sentiments exactly, unfortu
Aleksey Tsalolikhin writes:
> On Tue, Mar 31, 2009 at 6:35 PM, David Wilson
> wrote:
>> Have you tested "ssh node2" as the postgres user with SELinux enabled?
> Yes, I have, it works fine. With SELinux enabled. That's why I've
> been tearing my hair out.
Ah, well, you need to understand one
On Tue, Mar 31, 2009 at 6:35 PM, David Wilson wrote:
> On Tue, Mar 31, 2009 at 9:18 PM, Aleksey Tsalolikhin
> wrote:
>
>> Could not create directory '/home/postgres/.ssh'.
>> Host key verification failed.
>
> Have you tested "ssh node2" as the postgres user with SELinux enabled?
Yes, I have, it
On Tue, Mar 31, 2009 at 9:18 PM, Aleksey Tsalolikhin
wrote:
> Could not create directory '/home/postgres/.ssh'.
> Host key verification failed.
Have you tested "ssh node2" as the postgres user with SELinux enabled?
This looks like ssh failing to access the .ssh directory where it
keeps host keys
Ok, this is not strictly a PostgreSQL issue,
but I am trying to enable WAL log shipping on our PostgreSQL 8.1.10
(upgrade to 8.3.7 is in the works).
My archive_command is 'rsync %p postg...@node2:/file/to/$f http://www.verticalsysadmin.com/
LinkedIn - http://www.linkedin.com/in/atsaloli
--
Sent
On Tue, Mar 31, 2009 at 5:44 PM, Anderson Valadares
wrote:
> I have a software developed in Delphi as a Windows Service, but, i don't
> know why, it consumns an unexpected large system memory (1.3g).
>
> The service access PostgresSQL by ODBC driver (psqlodbc_08_03_0400) and it
> consist simply of
I have a software developed in Delphi as a Windows Service, but, i don't
know why, it consumns an unexpected large system memory (1.3g).
The service access PostgresSQL by ODBC driver (psqlodbc_08_03_0400) and it
consist simply of a loop calling a procedure PL/PGSQL. How to discover what
is causing
I am on Windows Server 2003 and humm I will have to check tommorow morning
but I do not think any Anti-Virus is scanning.
On Tue, Mar 31, 2009 at 6:53 PM, Scott Marlowe wrote:
> On Tue, Mar 31, 2009 at 2:10 PM, Patrick Desjardins
> wrote:
> > Hi,
> >
> > I have the error ERROR: XX001: could not
On Tue, Mar 31, 2009 at 2:10 PM, Patrick Desjardins
wrote:
> Hi,
>
> I have the error ERROR: XX001: could not read block 2354 of relation
> 1663/17633/17925: read only 0 of 8192 bytes, but only sometime, when trying
> to Insert data into a table. I would say that 99% of Insert works and 100%
> of
On Tue, Mar 31, 2009 at 08:57:28AM -0700, SHARMILA JOTHIRAJAH wrote:
> > Note you can find out by doing:
> > pg_dump dbname | wc
> Yes...I could find the space used after creating the dump.
> But I need to pre-allocate some space for storing these dumps
I'm not sure if you realize that you don't n
Hi,
I have the error ERROR: XX001: could not read block 2354 of relation
1663/17633/17925: read only 0 of 8192 bytes, but only sometime, when trying
to Insert data into a table. I would say that 99% of Insert works and 100%
of read works. This is only happenning since few weeks. I have done Vaccum
On Tue, 31 Mar 2009, chris.el...@shropshire.gov.uk wrote:
Been having interesting times with an IBM x3650 with 8 15k RPM 73GB
drives in RAID 10 and a ServRAID 8K controller with Write-Back cache
enabled (battery installed and working). Currently getting a pgbench
score of 4.7 transactions per
Hi all,
I wish to use a MPTT based table to store some hierachical datas. Here
is my table definition:
CREATE TABLE region (
id SERIAL NOT NULL,
full_path VARCHAR(255) NOT NULL,
lhs INTEGER NOT NULL,
rhs INTEGER NOT NULL,
level INTEGER NOT NULL,
parent
This thread being cross posted has made it a bit
confusing
Greg Stark wrote:
Nobody has ever suggested filtering out empty elements or dealing
specially with spaces or anything else like that. If you're talking
about that then you've missed the original question.
"Does anyone want t
On Tue, Mar 31, 2009 at 6:44 PM, justin wrote:
>
> Consider this. I have intelligent part numbers that need to be split apart
> to simplify searching and do math with.
>
> string_to_array(' F-2500-50 ', '-' ) ::int[]
Yeah, that's what I've said about three times. If you're building a
parser an
Hello,
As a reminder for all of those in our community that like to register at
the last minuted (that means most of us), registration will be closing
on Wednesday April first. On line registration is much easier than
registering at the door so please bounce on over to:
http://www.postgresql.us/p
Greg Stark wrote:
On Tue, Mar 31, 2009 at 5:48 PM, justin wrote:
But consider this fails also
select string_to_array('1, , 3', ',' )::int[] => ERROR: invalid input
syntax for integer: " "
yet this works
select string_to_array('1, 2, 3',',')::int[]
Sure, and the an
On Mar 31, 2009, at 6:41 PM, Harald Fuchs wrote:
In article <437faa9f-df2d-429e-9856-eb2026b55...@solfertje.student.utwente.nl
>,
Alban Hertroys writes:
You could add the columns you're sure that you need and put the rest
in an XML field.
If you have a problem and want to solve it using X
On Tue, Mar 31, 2009 at 5:48 PM, justin wrote:
>
> But consider this fails also
>
> select string_to_array('1, , 3', ',' )::int[] => ERROR: invalid input
> syntax for integer: " "
>
> yet this works
>
> select string_to_array('1, 2, 3',',')::int[]
Sure, and the analogous pair string_to_array('
Sam Mason wrote:
string_to_array('',',')::INT[] => invalid input syntax for integer: ""
Which you don't get at the moment; although you do currently get it in
other common cases such as:
string_to_array('1,',',')::INT[]
If you want backwards compatible behaviour you could always bung a
N
In article <437faa9f-df2d-429e-9856-eb2026b55...@solfertje.student.utwente.nl>,
Alban Hertroys writes:
> On Mar 30, 2009, at 5:39 PM, A B wrote:
>> Hi,
>> In the next project I'm going to have a number of colums in my tables,
>> but I don't know how many, they change. They all use integers as
>>
On Tue, Mar 31, 2009 at 10:31 AM, SHARMILA JOTHIRAJAH
wrote:
>
>
>
> --- On Tue, 3/31/09, Scott Marlowe wrote:
>
>> From: Scott Marlowe
>> wrote:
>> > But I need to pre-allocate some space for storing
>> these dumps (there are other databases too that needs to be
>> dumped). So Im trying to find
--- On Tue, 3/31/09, Scott Marlowe wrote:
> From: Scott Marlowe
> Subject: Re: [GENERAL] Space for pg_dump
> To: "SHARMILA JOTHIRAJAH"
> Cc: "General postgres mailing list"
> Date: Tuesday, March 31, 2009, 12:07 PM
> On Tue, Mar 31, 2009 at 9:57 AM,
> SHARMILA JOTHIRAJAH
>
> wrote:
> > But
Thank you so much Ray, I will give it a go.
Z
2009/3/31 Raymond O'Donnell :
> On 31/03/2009 16:58, zhang zhengquan wrote:
>> I would like to know how the my log data is organized in the database
>> and then I will see if I can do something to optimize the data entry
>> into the db.
>
> pgAdmin is
Sam Mason wrote:
I'd expect 3,2,1 and 1.
That's also a disingenuous example; what would you expect back from:
select count_elements(string_to_array('butter,,milk',','))
I think the semantics you want is what you'd get from:
array_filter_blanks(string_to_array($1,$2))
where I defined "arr
2009/3/31 Marcin Krol :
> Hello everyone,
>
> I'm having this completely weird problem that ORDER BY doesn't seem to work
> correctly in PG 8.1 as bundled in RedHat 5.
>
> When I issue:
>
> SELECT * FROM virtualization;
>
> I get all the fields:
>
> reservations=# SELECT * FROM virtualization;
> i
On 31/03/2009 16:58, zhang zhengquan wrote:
> I would like to know how the my log data is organized in the database
> and then I will see if I can do something to optimize the data entry
> into the db.
pgAdmin is a really good tool that lets you see all the objects in your
database in a tree view:
On Tue, Mar 31, 2009 at 4:34 PM, Sam Mason wrote:
>
> That's also a disingenuous example; what would you expect back from:
>
> select count_elements(string_to_array('butter,,milk',','))
>
> I think the semantics you want is what you'd get from:
>
> array_filter_blanks(string_to_array($1,$2))
>
>
On Tue, Mar 31, 2009 at 9:57 AM, SHARMILA JOTHIRAJAH
wrote:
> --- On Tue, 3/31/09, Scott Marlowe wrote:
>
>> From: Scott Marlowe
>> Subject: Re: [GENERAL] Space for pg_dump
>> To: "SHARMILA JOTHIRAJAH"
>> Cc: "General postgres mailing list"
>> Date: Tuesday, March 31, 2009, 11:49 AM
>> On Tue,
Hi, There,
I am a new sysadmin and I am new to postgresql and database. I have got
a very old gentoo server that has been running postgresql db for years
and now the log files alone are about 10 Giga bytes.
we run apache server and we have a ruby script that parse the
access_log of apache and p
On Tue, Mar 31, 2009 at 9:57 AM, SHARMILA JOTHIRAJAH
wrote:
> But I need to pre-allocate some space for storing these dumps (there are
> other databases too that needs to be dumped). So Im trying to find a space
> estimate
> Do you have a rough estimate of pg_dump in general... like 1/4 th
Long time reader, first time poster :-)
Postgresql 8.3.something
Windows Server 2003
So, the hard drive filled up this morning but server was still up. I
ran a few deletes some of them finished then the server crashed. Now it
won't start back up. Just getting could not start server on the co
--- On Tue, 3/31/09, Scott Marlowe wrote:
> From: Scott Marlowe
> Subject: Re: [GENERAL] Space for pg_dump
> To: "SHARMILA JOTHIRAJAH"
> Cc: "General postgres mailing list"
> Date: Tuesday, March 31, 2009, 11:49 AM
> On Tue, Mar 31, 2009 at 7:57 AM,
> SHARMILA JOTHIRAJAH
>
> wrote:
> >
> >
Hi,
Le mardi 31 mars 2009 à 17:35:58, Marcin Krol a écrit :
> [...]
> I'm having this completely weird problem that ORDER BY doesn't seem to
> work correctly in PG 8.1 as bundled in RedHat 5.
>
> When I issue:
>
> SELECT * FROM virtualization;
>
> I get all the fields:
>
> reservations=# SELECT *
On Mar 31, 2009, at 8:34 AM, Sam Mason wrote:
What do you really expect to be returned for things like
select count_elements(string_to_array('butter,tea,milk',','))
3 = {butter,tea,milk}
select count_elements(string_to_array('butter,tea',','))
2 = {butter,tea}
select count_elements(stri
Marcin Krol writes:
> When I issue:
> SELECT * FROM virtualization;
> I get all the fields:
> reservations=# SELECT * FROM virtualization;
> id | Virtualization | color
> +-+-
> But when I try to order by column Virtualization:
> reservations=# SELECT * FROM virt
On Tue, Mar 31, 2009 at 7:57 AM, SHARMILA JOTHIRAJAH
wrote:
>
> Hi,
> How much space does a pg_dump usually take?
> One of my databases is 600GB How much space do I need to dump this?
Note you can find out by doing:
pg_dump dbname | wc
--
Sent via pgsql-general mailing list (pgsql-general
On Tue, Mar 31, 2009 at 9:35 AM, Marcin Krol wrote:
> Hello everyone,
>
> I'm having this completely weird problem that ORDER BY doesn't seem to work
> correctly in PG 8.1 as bundled in RedHat 5.
>
> When I issue:
>
> SELECT * FROM virtualization;
>
> I get all the fields:
>
> reservations=# SELEC
SHARMILA JOTHIRAJAH wrote:
> Hi,
> How much space does a pg_dump usually take?
> One of my databases is 600GB How much space do I need to dump this?
That will depend on how many indexes etc. make up that 600GB. Also how
compressible your data is if you are using -Fc. Certainly less than a
"li
On Tue, Mar 31, 2009 at 8:54 AM, wrote:
>
> Scott Marlowe wrote on 31/03/2009 15:53:34:
>
>> On Tue, Mar 31, 2009 at 8:21 AM, wrote:
>> >
>> > Scott Marlowe wrote on 31/03/2009 15:16:01:
>> >
>> >> I'd call IBM and ask them to come pick up their boat anchors.
>> >
>> > My sentiments exactly,
Hello everyone,
I'm having this completely weird problem that ORDER BY doesn't seem to
work correctly in PG 8.1 as bundled in RedHat 5.
When I issue:
SELECT * FROM virtualization;
I get all the fields:
reservations=# SELECT * FROM virtualization;
id | Virtualization | color
+
Greg Stark writes:
> On Tue, Mar 31, 2009 at 3:42 PM, Sam Mason wrote:
>> string_to_array('',',')::INT[] => invalid input syntax for integer: ""
> Oof. That's a good point.
Isn't that an argument in favor of the zero-size-array definition?
regards, tom lane
--
Sent v
On Tue, Mar 31, 2009 at 03:43:37PM +0100, Greg Stark wrote:
> On Tue, Mar 31, 2009 at 7:45 AM, Brendan Jurd wrote:
> > My first thought was that it should be a zero-element array, because
> > then the string_to_array() behaviour would conform to the notion that
> > it returns an array with 1 eleme
Scott Marlowe wrote on 31/03/2009 15:53:34:
> On Tue, Mar 31, 2009 at 8:21 AM, wrote:
> >
> > Scott Marlowe wrote on 31/03/2009 15:16:01:
> >
> >> I'd call IBM and ask them to come pick up their boat anchors.
> >
> > My sentiments exactly, unfortunately, I seem stuck with them :(
>
> Can you
On Tue, Mar 31, 2009 at 8:21 AM, wrote:
>
> Scott Marlowe wrote on 31/03/2009 15:16:01:
>
>> I'd call IBM and ask them to come pick up their boat anchors.
>
> My sentiments exactly, unfortunately, I seem stuck with them :(
Can you at least source your own RAID controllers?
--
Sent via pgsql-g
On Tue, Mar 31, 2009 at 3:42 PM, Sam Mason wrote:
>
> string_to_array('',',')::INT[] => invalid input syntax for integer: ""
Oof. That's a good point.
--
greg
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.o
On Tue, Mar 31, 2009 at 7:45 AM, Brendan Jurd wrote:
> My first thought was that it should be a zero-element array, because
> then the string_to_array() behaviour would conform to the notion that
> it returns an array with 1 element per string fragment bounded by the
> delimiter.
>
> However, I no
On Tue, Mar 31, 2009 at 05:45:33PM +1100, Brendan Jurd wrote:
> On Tue, Mar 31, 2009 at 2:26 PM, Tom Lane wrote:
> > Does anyone want to argue for keeping it the same? Or perhaps
> > argue that a zero-element array is a more sensible result than
> > a one-element array with one empty string? (It
Scott Marlowe wrote on 31/03/2009 15:16:01:
> On Tue, Mar 31, 2009 at 3:37 AM, wrote:
> >
> > Hi
> >
> > Been having interesting times with an IBM x3650 with 8 15k RPM 73GB
drives
> > in RAID 10 and a ServRAID 8K controller with Write-Back cache enabled
> > (battery installed and working). Cu
On Tue, Mar 31, 2009 at 3:37 AM, wrote:
>
> Hi
>
> Been having interesting times with an IBM x3650 with 8 15k RPM 73GB drives
> in RAID 10 and a ServRAID 8K controller with Write-Back cache enabled
> (battery installed and working). Currently getting a pgbench score of 4.7
> transactions per sec
On Tuesday 31 March 2009 6:44:52 am Reid Thompson wrote:
> I've a DB and I want to migrate the users to a new empty DB. How do I
> dump/reload just the users?
>
> Thanks,
> reid
pg_dumpall -g
From:
http://www.postgresql.org/docs/8.3/interactive/app-pg-dumpall.html
-g
--globals-only
Dump on
Hi,
How much space does a pg_dump usually take?
One of my databases is 600GB How much space do I need to dump this?
Thanks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I've a DB and I want to migrate the users to a new empty DB. How do I
dump/reload just the users?
Thanks,
reid
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 31/03/2009 12:14, CM J wrote:
> D:\pgsql\bin\pg_ctl.exe -U postgres -P -w start -D D:\pgsql\data
I wonder if that -P is causing trouble? According to the output of
--help, there's no -P option with a START operation; however, -p is used
to specify the path to the postgres binaries.
Just a s
On Mar 30, 2009, at 5:39 PM, A B wrote:
Hi,
In the next project I'm going to have a number of colums in my tables,
but I don't know how many, they change. They all use integers as
datatype though.. One day, I get 2 new columns, a week later I loose
one column, and so on in a random pattern.
I
CM J wrote:
> Hi,
>
> I don't have multiple postgres installed.
Hmm. OK.
> Anyway, tried your suggestion
> to use the full path name and here is what i get:
>
> D:\pgsql\bin>D:\pgsql\bin\pg_ctl.exe -U postgres -P -w start
> -D:\pgsql\data
You've got a typo here - the "-D" has run into "D:\...
Hi,
Please ignore my previous mail. I had given data directory location
incorrectly.Anyways,even after giving the absolute path for exe location, i
get the same error message as before:
D:\pgsql\bin\pg_ctl.exe -U postgres -P -w start -D D:\pgsql\data
*waiting for server to start...FATAL
Hi,
I don't have multiple postgres installed.Anyway, tried your suggestion
to use the full path name and here is what i get:
D:\pgsql\bin>D:\pgsql\bin\pg_ctl.exe -U postgres -P -w start
-D:\pgsql\data
pg_ctl: could not open PID file ":/pgsql/data/postmaster.pid": Invalid
argument
On Tue, 31 Mar 2009, Thomas Pundt wrote:
Hi,
Ow Mun Heng schrieb:
I don't think I understand how PG implements fulltext searching or if my
search actually needs to use fulltext search.
No, that's something different. See the fine manual.
in 8.4 it will be possible to use prefix search in f
Hi,
I am working on packaging postgres database in our java based
application.I downloaded postgresql-8.2.12-1-binaries-no-installer.zip
from the postgres site and installed it on a windows 2003 machine
using administrator account.I later created a postgres service login
account and changed t
CM J wrote:
> pg_ctl.exe -U postgres -P -w start -D D:\pgsql\data
>
> However, i get the following error message:
>
> waiting for server to start...FATAL: postgres: could not locate matching
> postgres executable
That does seem to suggest it found the executable but it didn't match
ve
Hi,
I am working on packaging postgres database in our java based
application.I downloaded postgresql-8.2.12-1-binaries-no-installer.zip from
the postgres site and installed it on a windows 2003 machine using
administrator account.I later created a postgres service login account and
changed th
Hi
Been having interesting times with an IBM x3650 with 8 15k RPM 73GB drives
in RAID 10 and a ServRAID 8K controller with Write-Back cache enabled
(battery installed and working). Currently getting a pgbench score of 4.7
transactions per second! After playing with the postgresql configuratio
margaretgil...@chromalloy.com wrote:
> Using Postgresql 8.2.11 on Ubuntu 7.10.
>
> I am writing a J2EE project but do not want user specific schemas because
> this
> application sits on a production floor and any production employee can walk
> to a
> workstation and access the database to punc
Hi,
Ow Mun Heng schrieb:
I don't think I understand how PG implements fulltext searching or if my
search actually needs to use fulltext search.
No, that's something different. See the fine manual.
basically, I have a btree index on a SERIAL_NUMBER which is of sort like
ABC12345 or AAA123434
65 matches
Mail list logo
