Please note that your single Fibre Channel card is limiting you to 256MB/sec read speed from your array, which is not enough for a 13 drive RAID 5.First test would be to run a basic bonnie++ benchmark against your drive array and see what kind of throughput you are getting for linear read, linear w
Of course if you really want good performance, 6 drives is a little light, and U320 is definatley not the way to go as you are limited to 320MB/sec per channel (an the DL380 comes with all drives on one channel) (not that you could saturate that with only 6 drives in RAID 10 anyway). Given that th
Hi,
I´m planning to migrate from 7.4 to 8.0.7 and I discovered some strange
behavior during migration.
pg_dump inserted GRANT to phantom groups. They do not exist in pg_group;
When the script created by pg_dump is processed by psql during restore,
these GRANTs produce a lot of errors.
How could
> I hava a db server (mysql) in my web application, it include 550
> tables and about 10 rows in each table. Now, I want to change the
> db server to postgresql and construct a HA environment.
>
> I have two 2U servers to build postgresql server (one is master, the
> other is slave), and two 1
Clodoaldo Pinto worte:
-->-Mensagem original-
-->De: [EMAIL PROTECTED]
-->[mailto:[EMAIL PROTECTED] Em nome de
-->Clodoaldo Pinto
-->Enviada em: segunda-feira, 3 de julho de 2006 12:13
-->Para: pgsql-general postgresql.org
-->Assunto: Re: [GENERAL] php can't connect to postgresql serve
Hi Alban,
On 7/3/06, Alban Hertroys <[EMAIL PROTECTED]> wrote:
Alexander Farber wrote:
> punbb=> select username, md5('deadbeef' || password) from users where id
> = 4;
> username | md5
> --+--
> Vasja| dcde745cc304742e26d62e683a9ecb0a
>
Hi All,How to make the postgresql and application setup installer automatic.for example, I want to make a demo software for averyone but of course they want easy way. Just klik2 and the apllication software is ready to use.
Note: This is for desktop application made by VB 6.0So is there any way do
Thanks for all,It's really help me, I mean that give me a lot of clueBtw,
Now I still reinstall the postgres coz i dont know why suddenly i can't
start the services. that's why i ask how to backup the data when the
serviceis down.
I'll try it and thanks for helpRegard,Jokonet
Joost,
Everyone has to do a select for update, then they will be serialized.
Dave
On 3-Jul-06, at 6:45 AM, Joost Kraaijeveld wrote:
Hi,
I have a table with events that must be handled by multiple
clients. It
does not matter which client handles an event, but no two clients may
handle the s
This is not exactly what I'm searching for, but thanks..
David
__
TL> David Hoksza <[EMAIL PROTECTED]> writes:
>> Hi, is there a way how to get some more detailed times for query
>> execution like Kernel Time, User Time and Process Time?
TL> See log_statement_stats and friends...
T
Vivek Khera wrote:
if you want to use the freebsd ports system (which is advisable) don't
fight against it. use the recommended/defaults where you can.
I wasn't trying to fight it. It's just that the port disagrees with the
PG documentation and apparently most other ports. The maintainer sa
Tom Lane wrote:
Jacob Coby <[EMAIL PROTECTED]> writes:
I then tried:
foo=# select * from pg_catalog.pg_statistic ;
ERROR: could not access status of transaction 3242180415
DETAIL: could not open file "pg_clog/0C13": No such file or directory
so it seems that pg_catalog.pg_statistic has someh
I hava a db server (mysql) in my web application, it include 550
tables and about 10 rows in each table. Now, I want to change the
db server to postgresql and construct a HA environment.
I have two 2U servers to build postgresql server (one is master, the
other is slave), and two 1U servers f
> Can't the intelligent practitioner simply proceed carefully with
> queries when nulls are involved?
Yes. The thing is, getting rid of NULL in the real world requires
decomposing data into so many tables that it would certainly cause more
confusion when it comes time to actually query the data...
On Jul 2, 2006, at 9:55 AM, Joe wrote:
I'm now migrating to FreeBSD and was surprised to find that the
port used 'pgsql' as the user. The maintainer said that was done
to ensure backward compatibility because that *was* the original
name. Since I didn't need to be backward compatible (an
Alexander Farber wrote:
I wonder, what is faster: fetching 2 columns - the
username and the md5-result and then comparing the
md5 string against the argument in my app, like here:
punbb=> select username, md5('deadbeef' || password) from users where id
= 4;
username | md5
---
Merlin Moncure wrote:
* mysql has a few features here and there which are nice...just to
name a few, flush tables with lock, multiple insert, etc
PostgreSQL does have multiple inserts, but complying to the SQL92
standard, through INSERT (...) SELECT ...
For example:
INSERT INTO my_table (id,
On Friday 30 June 2006 09:17, Jason McManus wrote:
> On Converting from MySQL 5.0.x to PostgreSQL 8.1.x
> * There is a conversion utility called 'mysql2pgsql' that will convert
> dump files from the mysqldump format, to a format that psql can
> understand. It is available at:
> - http://gbor
On Mon, 2006-07-03 at 17:03, Tom Lane wrote:
> status and TX2's select will not return the row. This isn't entirely
> perfect because LIMIT acts before FOR UPDATE: TX2's select will return
> nothing, rather than selecting the next available row as you might wish.
> So you might want to retry the s
Steven Ridgway <[EMAIL PROTECTED]> writes:
> 2) Occasionally (3 times in the last 2 months) the database locks up. When
> this happens the log file contains a bunch of errors along the lines of :
> 2006-06-26 14:53:40 LOG: could not fsync segment 0 of relation
> 1663/16672/50807554: Perm
2006/7/3, Clodoaldo Pinto <[EMAIL PROTECTED]>:
php can't connect to postgresql server
php error log message:
PHP Warning: pg_connect() [function.pg-connect]: Unable to connect
to PostgreSQL server: could not connect to server: Permission
denied\n\tIs the server running on host "127.0.0.1" and
David Hoksza <[EMAIL PROTECTED]> writes:
> Hi, is there a way how to get some more detailed times for query
> execution like Kernel Time, User Time and Process Time?
See log_statement_stats and friends...
regards, tom lane
---(end of broadcast)
Joost Kraaijeveld <[EMAIL PROTECTED]> writes:
> I have a table with events that must be handled by multiple clients. It
> does not matter which client handles an event, but no two clients may
> handle the same event and an event may only handled once. A client can
> only determine the availability
2006/7/3, Robert Treat <[EMAIL PROTECTED]>:
On Monday 03 July 2006 09:25, Clodoaldo Pinto wrote:
> php can't connect to postgresql server
>
> php error log message:
>
> PHP Warning: pg_connect() [ href='function.pg-connect'>function.pg-connect]: Unable to connect
> to PostgreSQL server: could no
On Mon, Jul 03, 2006 at 06:57:03AM -0700, Steven Ridgway wrote:
> Hi,
> We have been having some problems with a postgres database recently and
> would appreciate any advice or pointers.
>
> Environment:
> Postgres 8.1.4 running on Windows Server 2003 Enterprise x64 Edition
> (installed
Hi, We have been having some problems with a postgres database recently and would appreciate any advice or pointers. Environment: Postgres 8.1.4 running on Windows Server 2003 Enterprise x64 Edition (installed using standard win32 installer). Quad (2 x dual core) AMD Opteron 870. 8Gb RAM
On Monday 03 July 2006 09:25, Clodoaldo Pinto wrote:
> php can't connect to postgresql server
>
> php error log message:
>
> PHP Warning: pg_connect() [ href='function.pg-connect'>function.pg-connect]: Unable to connect
> to PostgreSQL server: could not connect to server: Permission
> denied\n\tIs
2006/7/3, A. Kretschmer <[EMAIL PROTECTED]>:
am 03.07.2006, um 10:25:29 -0300 mailte Clodoaldo Pinto folgendes:
> $conn_string = "hostaddr=127.0.0.1 port=5432 dbname=dbname
^
> I can connect as that user with psql:
>
> $ psql -h localhost -U username dbname
Yes, you're probably right.
I'm just trying to ensure, that the slow md5() function isn't
called for every row in the table. If that's not the case, then
the other tiny speed differences are not that important for me.
Your query works too, thanks for the hint.
punbb=> select username, md5('dead
[Please copy the mailing list on replies so others can contribute
to and learn from the discussion.]
On Mon, Jul 03, 2006 at 01:20:53PM +1000, Peter Dawn wrote:
> i executed this query (SELECT uf_purge(365)) within PGAdmin and the
> query executed successfully (the output was row1 uf_urge(bool) t.
am 03.07.2006, um 10:25:29 -0300 mailte Clodoaldo Pinto folgendes:
> $conn_string = "hostaddr=127.0.0.1 port=5432 dbname=dbname
^
> I can connect as that user with psql:
>
> $ psql -h localhost -U username dbname
^
Try 'localhost' instead '
On Mon, 2006-07-03 at 07:54 -0400, Douglas McNaught wrote:
> Have all the clients use SELECT FOR UPDATE.
OK, thanks, your answer lead me to a re-read of the docs and I think I
found a way to do it.
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063
php can't connect to postgresql server
php error log message:
PHP Warning: pg_connect() [function.pg-connect]: Unable to connect
to PostgreSQL server: could not connect to server: Permission
denied\n\tIs the server running on host "127.0.0.1" and
accepting\n\tTCP/IP connections on port 5432?
p
On Mon, Jul 03, 2006 at 03:13:15PM +0200, Alexander Farber wrote:
> Hello,
>
> in my application I'm trying to authenticate users
> against a table called "users". The integer column
> "id" should match, but also an md5 hash of the
> "password" column (salted with a string) should match.
> My auth
Hello,
in my application I'm trying to authenticate users
against a table called "users". The integer column
"id" should match, but also an md5 hash of the
"password" column (salted with a string) should match.
My authentication function (written in C, using libpq)
should return a "username" (is
Hello,
I would appreciate your benchmarks greatly... I think that they would
be useful for many small companies running PostgreSQL since virtual
private servers seem to be very effective solution for organizing many
secure and separate services on single physical machine. We just need
to understa
On Mon, Jul 03, 2006 at 12:55:18AM -0400, Tom Lane wrote:
> Fine for you, not so fine for other people with different concerns.
>
> I'm not unsympathetic to your general point, but black-and-white
> arguments won't get far in this discussion. It's all about tradeoffs
> ... it's most definitely no
Tom Lane wrote:
Dragan Matic <[EMAIL PROTECTED]> writes:
I was about to say the same thing. I think that the whole point in
having a portable database system is that the data inside the database
should behave the _same way_ no matter what operating system database is
running on - client sho
Joost Kraaijeveld <[EMAIL PROTECTED]> writes:
> I have read the manual about "LOCK", "SET TRANSACTION" and "SELECT...FOR
> UPDATE", but from what I understand, they cannot prevent a "SELECT" from
> another client, based on the "SELECT".
>
> Is there a way to make this possible?
Have all the clien
Hi, is there a way how to get some more detailed times for query
execution like Kernel Time, User Time and Process Time? I would like
see the time which PG really spends with computing without times from
another processes (I'm running on Windows with PostgreSQL 8.1.3.).
Thanks,
David Hoksza
Hi,
I have a table with events that must be handled by multiple clients. It
does not matter which client handles an event, but no two clients may
handle the same event and an event may only handled once. A client can
only determine the availability of an event by querying the database.
The access
41 matches
Mail list logo
