about plans). at the moment you can only
do replication
with a master (where writes go to) and serveral slaves (where you can
read from), but i need a system with the ability to do synchronous
replication
between two or more masters to have a HA mysql cluster. but this is not
offered by postgreSQL
On 3/5/04 10:49 AM, "Ben Yau" wrote:
> I too have had similar concerns. I always thought of postgresql as the
> "stable" database and mysql as the, well, "development" database or
> "non-mission-critical" database. Esp. since mysql didn&#x
about plans). at the moment you can only
do replication
with a master (where writes go to) and serveral slaves (where you can
read from), but i need a system with the ability to do synchronous
replication
between two or more masters to have a HA mysql cluster. but this is not
offered by postgreSQL
On 3/5/04 10:49 AM, "Ben Yau" wrote:
> I too have had similar concerns. I always thought of postgresql as the
> "stable" database and mysql as the, well, "development" database or
> "non-mission-critical" database. Esp. since mysql didn&#x
I have worked with Oracle, MS-SQL, Sybase, PostgreSQL and MySQL. For smaller
applications like
you are describing, MySQL wins hands down.
I currently have one table that has over 5 million rows (distance between any
two zip (postal)
codes that are >= 50 miles apart in the US), and it works
I have worked with Oracle, MS-SQL, Sybase, PostgreSQL and MySQL. For smaller
applications like
you are describing, MySQL wins hands down.
I currently have one table that has over 5 million rows (distance between any two zip
(postal)
codes that are >= 50 miles apart in the US), and it works
ast
> and are perfectly able to scope with high number of read and writes.
>
I too have had similar concerns. I always thought of postgresql as the
"stable" database and mysql as the, well, "development" database or
"non-mission-critical" database.
performance
-but bad performence for simultanious read and writes!
innodb
-transactions
-fast but little bit slower than myISAM
-can handle high volume simultaniously reads and writes.
> Also we've read that PostgreSQL is very slow on such records.
Sounds like old/wrong info to m
ast
> and are perfectly able to scope with high number of read and writes.
>
I too have had similar concerns. I always thought of postgresql as the
"stable" database and mysql as the, well, "development" database or
"non-mission-critical" database.
performance
-but bad performence for simultanious read and writes!
innodb
-transactions
-fast but little bit slower than myISAM
-can handle high volume simultaniously reads and writes.
> Also we've read that PostgreSQL is very slow on such records.
Sounds like old/wrong info to m
00 records and more. Also
> we've read that PostgreSQL is very slow on such records.
> But we don't have any experience, so we must rely on other people
> experience.
How big are these records? Usually records are no more than 1K in size, so
the entire database should fit into
#x27;t do certain
> subselects, triggers...).
MySQL seems to perform quite good on small amounts of data and limited
selects. This is why it's used so much for web development.
Personally, I'd use PostgreSQL. It's stable and can handle large tables.
And, it's faster (most of t
Hi
We're planning a new website where we will use a DB with 500.000 to 1.000.000
records. We are now deciding which database server we will use. We've read
that MySQL has big problems from 150.000 records and more. Also we've read
that PostgreSQL is very slow on such records.
Bu
00 records and more. Also
> we've read that PostgreSQL is very slow on such records.
> But we don't have any experience, so we must rely on other people
> experience.
How big are these records? Usually records are no more than 1K in size, so
the entire database should fit into
tain
> subselects, triggers...).
MySQL seems to perform quite good on small amounts of data and limited
selects. This is why it's used so much for web development.
Personally, I'd use PostgreSQL. It's stable and can handle large tables.
And, it's faster (most of the
Hi
We're planning a new website where we will use a DB with 500.000 to 1.000.000
records. We are now deciding which database server we will use. We've read
that MySQL has big problems from 150.000 records and more. Also we've read
that PostgreSQL is very slow on such records.
Bu
On Fri, Jul 18, 2003 at 08:44:07PM +0200,
Miernik <[EMAIL PROTECTED]> wrote
a message of 9 lines which said:
> DHCP servers usually store the MAC -> IP resolution in a
> /etc/dhcpd.conf file. I am looking for one that can use a PostgreSQL
> database for that puropuse.
IMHO
DHCP servers usually store the MAC -> IP resolution in a
/etc/dhcpd.conf file. I am looking for one that can use a PostgreSQL
database for that puropuse.
--
Miernik jabber:[EMAIL PROTECTED]
__ ICQ: 4004001 ___/__ tel: +48608233394 __/ mailto:[EM
Hello,
Horde/Imp/PostgreSql works perfect.
In our Company we have this installation, specially we have installed
the tar.gz files from horde.org
Unpack the horde.tar.gz (v2.0) into your webroot, the imp into the
horde-folder.
Your problem is, the access-permissions in the file pg_hba.conf.
The
Hello,
Horde/Imp/PostgreSql works perfect.
In our Company we have this installation, specially we have installed
the tar.gz files from horde.org
Unpack the horde.tar.gz (v2.0) into your webroot, the imp into the
horde-folder.
Your problem is, the access-permissions in the file pg_hba.conf.
The
Hummm,
I'm using the default configuration, right from the "box", though I agree
with you. I been scrambling my postgres config files and get no result. Can
you give me any lead.
Thanks,
rak
On Wed, Oct 09, 2002 at 05:53:33PM +0200, Christian Zagrodnick wrote:
> Hi
>
> you have chosen i
Hummm,
I'm using the default configuration, right from the "box", though I agree
with you. I been scrambling my postgres config files and get no result. Can
you give me any lead.
Thanks,
rak
On Wed, Oct 09, 2002 at 05:53:33PM +0200, Christian Zagrodnick wrote:
> Hi
>
> you have chosen
Quoting UnKnown <[EMAIL PROTECTED]>:
> Hi all, again, I'm having some troubles configuring the imp,
> after traying allmost evrything,
This is about the only real problem that I have had
with Debian in years of running it on my servers.
When I was upgrading some time in May I think, IMP would
no
Quoting UnKnown <[EMAIL PROTECTED]>:
> Hi all, again, I'm having some troubles configuring the imp,
> after traying allmost evrything,
This is about the only real problem that I have had
with Debian in years of running it on my servers.
When I was upgrading some time in May I think, IMP would
n
Hi all, again, I'm having some troubles configuring the imp, after traying
allmost evrything, I still recive the same error when opening the imp page
Trascrip..
Warning: Unable to connect to PostgresSQL server: FATAL 1: IDENT
authentication failed for user "hordemgr" in /etc/horde/db_pgsql.in
Hi all, again, I'm having some troubles configuring the imp, after traying
allmost evrything, I still recive the same error when opening the imp page
Trascrip..
Warning: Unable to connect to PostgresSQL server: FATAL 1: IDENT
authentication failed for user "hordemgr" in /etc/horde/db_pgsql.i
org
Betreff: Re: Subject: ip accounting -> PostgreSQL
All what we need is: source IP, destination IP, source port, destination
port, bytes, time.
For now nacctd periodically stores this information in the text file, and
simple perl script (periodically) moves fresh data to MySQL.
But we like
but the main
> > question is to store accounting information into PostgreSQL database.
> > Any suggestions?
On Mit, 06 Feb 2002, Nicholay P. Chuprynin wrote:
> We need to do IP based traffic accounting on our server, but the main
> question is to store accounting information into PostgreSQL database.
> Any suggestions?
You have to recompile the ipac-ng package to support
postgresql. If you
Hello All.
We need to do IP based traffic accounting on our server, but the main
question is to store accounting information into PostgreSQL database.
Any suggestions?
Thanks,
Nicholay
ff: Re: Subject: ip accounting -> PostgreSQL
All what we need is: source IP, destination IP, source port, destination
port, bytes, time.
For now nacctd periodically stores this information in the text file, and
simple perl script (periodically) moves fresh data to MySQL.
But we like the idea
but the main
> > question is to store accounting information into PostgreSQL database.
> > Any suggestions?
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
On Mit, 06 Feb 2002, Nicholay P. Chuprynin wrote:
> We need to do IP based traffic accounting on our server, but the main
> question is to store accounting information into PostgreSQL database.
> Any suggestions?
You have to recompile the ipac-ng package to support
postgresql. If you
Hello All.
We need to do IP based traffic accounting on our server, but the main
question is to store accounting information into PostgreSQL database.
Any suggestions?
Thanks,
Nicholay
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Cont
When I do a dpk-reconfigure libpam-ldap and I set the root login =
cn=admin, dc=< ?? > What do I put for dc?
If I am using debian.org as my ldap server location would I have
cn=admin, dc=debian, dc=com?
I am confused, after I configured the ldap again I got ldap_bind:
Invalid credentials which
>
>When I do a dpk-reconfigure libpam-ldap and I set the root login =
>cn=admin, dc=< ?? > What do I put for dc?
>If I am using debian.org as my ldap server location would I have
>cn=admin, dc=debian, dc=com?
>I am confused, after I configured the ldap again I got ldap_bind:
>Invalid credenti
After looking into this more I can see that it is my ldap configuration.
I am using slapd.
When I do a dpk-reconfigure libpam-ldap and I set the root login =
cn=admin, dc=< ?? > What do I put for dc?
If I am using debian.org as my ldap server location would I have
cn=admin, dc=debian, dc=com?
I
Hi,
The problem with it connecting and installing the database works good
now, but it cannot connect to the ldap server? What is going on, would
it be due to a config problem, or is it the package?
Thanks,
Matt
Setting up sourceforge (2.5-14) ...
You'll see some debugging info during this install
After looking into this more I can see that it is my ldap configuration.
I am using slapd.
When I do a dpk-reconfigure libpam-ldap and I set the root login =
cn=admin, dc=< ?? > What do I put for dc?
If I am using debian.org as my ldap server location would I have
cn=admin, dc=debian, dc=com?
Hi,
The problem with it connecting and installing the database works good
now, but it cannot connect to the ldap server? What is going on, would
it be due to a config problem, or is it the package?
Thanks,
Matt
Setting up sourceforge (2.5-14) ...
You'll see some debugging info during this instal
Has anyone installed sourceforge with the deb package?
I am installing it and this is my output:
Setting up sourceforge (2.5-14) ...
You'll see some debugging info during this installation.
Do not worry unless told otherwise.
DBI->connect(dbname=sourceforge;host=192.168.10.2) failed: fe_senda at
/
Has anyone installed sourceforge with the deb package?
I am installing it and this is my output:
Setting up sourceforge (2.5-14) ...
You'll see some debugging info during this installation.
Do not worry unless told otherwise.
DBI->connect(dbname=sourceforge;host=192.168.10.2) failed: fe_senda at
Please do not use HTML in email. This is a mailing list, not a website.
On Mon, Sep 10, 2001 at 13:15:16 +0200, Qwazz wrote:
>I neet to configure postgres for many user that can use it in remote. I
>don't understand if is possible to create users that can use ONLY 1
>database (create table, drop
Hi All!
This's my first post i don't know if
I'm Offtopic or not! In this case Sorry!
I neet to configure postgres for many user that can
use it in remote. I don't understand if is possible to create users that can use
ONLY 1 database (create table, drop table...) and that can't create onothe
Your message, PHP3 and Postgresql,
was not delivered to the following recipient:
[EMAIL PROTECTED]
Reason: System error: Please re-send your message later.
Recipient: [EMAIL PROTECTED]
I am still having problem running PHP3 with Postgresql.
Though I load all the modules. Now, when I run php3
files, I get nothing except "server could be down or
not responding.
Any help will be appricaited.
Thanks
Abu Umair
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subje
On Tue, Aug 07, 2001 at 16:07:46 -0500, Y2KNET wrote:
>Fatal error: Call to unsupported and undefined function pg_connect()
>in /html/trans/view.php3 on line 5.
You need to load the PostgreSQL connection module, either explicitly in your
php code, or globally by having &quo
You need to have libpq.so available to your run-time linker.
If you have PostgreSQL installed in the default /usr/local/pgsql/
location, just append "/usr/local/pgsql/lib/" to the end of your
/etc/ld.so.conf file and run ldconfig (you need to be root to do this).
If you cannot be root
I am trying to run some php3 script on Postgresql
and get the
following error:
Fatal error: Call to unsupported and
undefined function pg_connect() in /html/trans/view.php3 on line 5.
I have psql running and setup the srm.conf
httpd.conf files.
This is a first time I am using php3. I
Hi :)
I'm looking for a solution for my
problem...
I've got a Zmailer server, and my boss want a
"module"/program for capture all smtp mails and introduce this in a postgresql
or mysql database. And (of course), the same for get the mail (yes yes...), when
the clien
Hi :)
I'm looking for a solution for my
problem...
I've got a Zmailer server, and my boss want a
"module"/program for capture all smtp mails and introduce this in a postgresql
or mysql database. And (of course), the same for get the mail (yes yes...), when
the clien
Hi :)
I'm looking for a solution for my
problem...
I've got a Zmailer server, and my boss want a
"module"/program for capture all smtp mails and introduce this in a postgresql
or mysql database. And (of course), the same for get the mail (yes yes...), when
the clien
Hi :)
I'm looking for a solution for my
problem...
I've got a Zmailer server, and my boss want a
"module"/program for capture all smtp mails and introduce this in a postgresql
or mysql database. And (of course), the same for get the mail (yes yes...), when
the clien
53 matches
Mail list logo
