On 26/06/2010 2:07 AM, Joshua D. Drake wrote:
On Fri, 2010-06-25 at 23:24 +0530, RP Khare wrote:
I never used PostgreSQL in production environment. Now I got an
opportunity to migrate a MySQL production database to PostgreSQL.
Before migrating, I have few queries on data recovery:
1. Is t
On 06/25/10 9:28 PM, Felipe de Jesús Molina Bravo wrote:
original perl is 5.6. so i installed perl 5.8.9 for 64 bit and the
error is the same... maybe my error is with the compiler, it is "gcc"
(3.4.6). is it possible?
where did this 64bit 5.8.9 come from?
I try to downloaded SunStudio
2010/6/25 John R Pierce
> On 06/25/10 2:21 PM, MOLINA BRAVO FELIPE DE JESUS wrote:
>
>> Hi
>>
>> I don't have experience with solaris. I know it is a 64 bits:
>>
>> bash-2.05# isainfo -v
>> 64-bit sparcv9 applications
>> 32-bit sparc applications
>>
>>
>>
>> I tried to compile postgres (Version o
On 6/25/2010 4:22 AM, John Gage wrote:
There are features, are there not, that Postgres has that MySQL does not
have?
Yes, a big one would be data integrity. Most people would not consider
data integrity an optional feature in a DBMS, but apparently MySQL does.
Try this in MySQL:
create t
On Friday 25 June 2010 4:59:17 pm Dennis C wrote:
> OK well the gunzip seemed to "do the trick," but I don't recall before
> having to do anything other than run the pg_restore command. Anyway,
> thanks to everyone for all your help!
My guess is that previously the dump command was actually:
/op
OK well the gunzip seemed to "do the trick," but I don't recall before
having to do anything other than run the pg_restore command. Anyway, thanks
to everyone for all your help!
On Fri, Jun 25, 2010 at 11:29 AM, Adrian Klaver wrote:
> On 06/25/2010 09:04 AM, Dennis C wrote:
>
>> It says "Tradin
On 06/25/10 2:21 PM, MOLINA BRAVO FELIPE DE JESUS wrote:
Hi
I don't have experience with solaris. I know it is a 64 bits:
bash-2.05# isainfo -v
64-bit sparcv9 applications
32-bit sparc applications
I tried to compile postgres (Version of postgres: 8.4.4 ) with plperl for 64
bits. The option
Hi
I don't have experience with solaris. I know it is a 64 bits:
bash-2.05# isainfo -v
64-bit sparcv9 applications
32-bit sparc applications
I tried to compile postgres (Version of postgres: 8.4.4 ) with plperl for 64
bits. The options for the configure are:
/configure --with-CC=/usr/local
Hi
I don't have experience with solaris. I know it is a 64 bits:
bash-2.05# isainfo -v
64-bit sparcv9 applications
32-bit sparc applications
I tried to compile postgres (Version of postgres: 8.4.4 ) with plperl for 64
bits. The options for the configure are:
/configure --with-CC=/usr/local/bi
On Fri, 25 Jun 2010 08:48:11 -0700
Rob Wultsch wrote:
> The freedom of the storage engine interface allows for much more
> varied backend characteristics. Some examples:
This is *really* fascinating but pg transactional engine is very
mature and solid.
Before any of the should-be-really-transact
I am having an issue with extracting data from the arguments within my ‘C’
function, inside my Stored Library.
Let’s put the pieces together first:
I have a type called rank_post which has two one character fields:
CREATE TYPE rank_post AS
(
rank character(1),
post character(1)
);
I am usin
On 06/25/2010 09:04 AM, Dennis C wrote:
It says "Trading-Access: gzip compressed data, from Unix"
About the idea of not using pg_restore for these dumps, what I'm still
missing is how it's worked for all these years before. Are there now more
stringent standards being enforced?
You have res
On 06/25/10 4:10 AM, javijava wrote:
i need to know how to do a simple script that create a database,the y
select it (in other languajes using USE) and after create tables with this
database.
How can I say "use name_database" on postgre sql?
Thanks in advance 4 the help!!
IF you are usi
On Fri, 2010-06-25 at 23:24 +0530, RP Khare wrote:
> I never used PostgreSQL in production environment. Now I got an
> opportunity to migrate a MySQL production database to PostgreSQL.
> Before migrating, I have few queries on data recovery:
>
> 1. Is there any feature of scheduled backups?
I never used PostgreSQL in production environment. Now I got an opportunity to
migrate a MySQL production database to PostgreSQL. Before migrating, I have few
queries on data recovery:
Is there any feature of scheduled backups?In case there is no backup and I want
to shift my data files to a n
On Fri, Jun 25, 2010 at 09:44:04AM +0100, Dave Page wrote:
> It could also be argued that having a storage engine API means that
> the query planner/optimiser cannot have nearly as much knowledge
> about how the data is stored and what access characteristics it may
> have thus preventing it from be
On Fri, Jun 25, 2010 at 10:00 AM, Tom Lane wrote:
> Scott Marlowe writes:
> > On Fri, Jun 25, 2010 at 7:10 AM, javijava
> wrote:
> >> How can I say "use name_database" on postgre sql?
>
> > You have to re-connect to use a different db in pgsql.
>
> But keep in mind that mysql databases are more
On Jun 23, 2010, at 6:01 PM, A.M. wrote:
> Hello,
>
> I am trying to make a query which will flatten pg_auth_members into a table
> with two columns "user" and "group" which will recurse inherited roles so
> that each login role is associated once with any inherited roles (assuming
> all asso
On Fri, Jun 25, 2010 at 8:56 AM, Scott Marlowe wrote:
> On Fri, Jun 25, 2010 at 11:48 AM, Rob Wultsch wrote:
>> - Innodb : The primary transactional storage engine for MySQL. It does
>> not have all the features of PG (like check contraints), but it has
>> some features (like Compression!!!) whic
It says "Trading-Access: gzip compressed data, from Unix"
About the idea of not using pg_restore for these dumps, what I'm still
missing is how it's worked for all these years before. Are there now more
stringent standards being enforced?
On Fri, Jun 25, 2010 at 8:37 AM, Thom Brown wrote:
> O
On Fri, Jun 25, 2010 at 4:58 AM, Scott Marlowe wrote:
> Next up: PostgreSQL stores its system catalogs in transaction safe
> table types, like everything else it stores. MySQL stores its table
> defs in myisam, even if the whole of the db you create is innodb and
> innodb is the default. System
On Fri, 2010-06-25 at 08:28 -0700, Dennis C wrote:
> Greetings;
>
>
> As I've been doing for quite some time, backed up my database as
> such: /opt/local/lib/postgresql84/bin/pg_dump -c -f ./Trading-Access
> -Z 5 Trading-Access
>
>
> But then when I tried restoring it my usual way as
> such: /o
On Fri, Jun 25, 2010 at 11:48 AM, Rob Wultsch wrote:
> - Innodb : The primary transactional storage engine for MySQL. It does
> not have all the features of PG (like check contraints), but it has
> some features (like Compression!!!) which are *exceptionally* useful.
You do know that pg has compr
On Fri, Jun 25, 2010 at 1:44 AM, Dave Page wrote:
> On Fri, Jun 25, 2010 at 9:33 AM, Rob Wultsch wrote:
>> MySQL has several full text search solutions. The built in MyISAM
>> solution is the best known, but there is also an engine for using
>> sphinx.
>>
>> ...
>>
>> And there are features that
On 25 June 2010 16:28, Dennis C wrote:
> Greetings;
> As I've been doing for quite some time, backed up my database as
> such: /opt/local/lib/postgresql84/bin/pg_dump -c -f ./Trading-Access -Z 5
> Trading-Access
> But then when I tried restoring it my usual way as
> such: /opt/local/lib/postgresql
Greetings;
As I've been doing for quite some time, backed up my database as
such: /opt/local/lib/postgresql84/bin/pg_dump -c -f ./Trading-Access -Z 5
Trading-Access
But then when I tried restoring it my usual way as
such: /opt/local/lib/postgresql84/bin/pg_restore -d Trading-Access
./Trading-Acce
Excerpts from Dick Kniep's message of vie jun 25 04:54:15 -0400 2010:
> PROBLEM 2
>
>
>
> Furthermore the following errors are shown:
>
>
>
> psql:db03.ak1.sql:251166: ERROR: column a.transaction does not exist
> LINE 2: SELECT (a.relation)::regclass AS "table", a."transaction...
>
Jim Montgomery writes:
> Remove me from your email chain.
Jim, are you trying to win the Jerk of the Month award? There's an
unsubscribe link on every PG list message. All you're accomplishing
with this is to annoy other list members who cannot unsubscribe you.
regards,
On 25/06/10 19:10, javijava wrote:
>
> Hi,
>
> i'm newby in postgre sql world.
>
> i need to know how to do a simple script that create a database,the y
> select it (in other languajes using USE) and after create tables with this
> database.
http://wiki.postgresql.org/wiki/FAQ
http://www.code
On Jun 25, 2010, at 10:48 AM, Scott Marlowe wrote:
> On Fri, Jun 25, 2010 at 7:10 AM, javijava wrote:
>>
>> Hi,
>>
>> i'm newby in postgre sql world.
>>
>> i need to know how to do a simple script that create a database,the y
>> select it (in other languajes using USE) and after create table
Scott Marlowe writes:
> On Fri, Jun 25, 2010 at 7:10 AM, javijava wrote:
>> How can I say "use name_database" on postgre sql?
> You have to re-connect to use a different db in pgsql.
But keep in mind that mysql databases are more nearly akin to what
postgres calls schemas. The best way to do w
javijava wrote:
> i'm newby in postgre sql world.
> i need to know how to do a simple script that create a database,the y
> select it (in other languajes using USE) and after create tables with this
> database.
> How can I say "use name_database" on postgre sql?
You must specify the database
On Fri, Jun 25, 2010 at 7:10 AM, javijava wrote:
>
> Hi,
>
> i'm newby in postgre sql world.
>
> i need to know how to do a simple script that create a database,the y
> select it (in other languajes using USE) and after create tables with this
> database.
>
>
> How can I say "use name_database" o
Hi List,
Thanks for this great product.
We have a database with many schema's and we are trying to migrate the db from
version 8.1.9 to 8.3.8.
So we made a pg_dumpall.
Now, when we try to restore with psql, we get loads of errors and warnings:
PROBLEM 1
psql:db03.ak1.sql:101
On Thu, Jun 24, 2010 at 10:03 PM, Jim Montgomery wrote:
> Remove me from your email chain.
>
Remove yourself.
--
Rob Wultsch
wult...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-ge
Remove me from your email chain.
> Date: Thu, 24 Jun 2010 21:57:15 -0400
> Subject: Re: [GENERAL] Need Some Recent Information on the Differences
> between Postgres and MySql
> From: scott.marl...@gmail.com
> To: wult...@gmail.com
> CC: mary.y.w...@boeing.com; pgsql-general@postgresql.org
>
>
Hi,
i'm newby in postgre sql world.
i need to know how to do a simple script that create a database,the y
select it (in other languajes using USE) and after create tables with this
database.
How can I say "use name_database" on postgre sql?
Thanks in advance 4 the help!!
--
View this messa
On Fri, Jun 25, 2010 at 2:02 PM, Jim Montgomery wrote:
> Remove me from your email chain.
You need to unsubscribe from the mailing list. Until now your weren't
explicitly included on any of the messages that I can see.
http://www.postgresql.org/community/lists/
--
Dave Page
EnterpriseDB UK: ht
Remove me from your email chain!
> Date: Fri, 25 Jun 2010 08:13:36 -0400
> Subject: Re: [GENERAL] Need Some Recent Information on the Differences
> between Postgres and MySql
> From: scott.marl...@gmail.com
> To: jsmg...@numericable.fr
> CC: wult...@gmail.com; mary.y.w...@boeing.com; pgsql-gene
Remove me from your email chain.
> Date: Fri, 25 Jun 2010 10:44:34 +0100
> Subject: Re: [GENERAL] Need Some Recent Information on the Differences
> between Postgres and MySql
> From: dp...@pgadmin.org
> To: andreas.kretsch...@schollglas.com
> CC: pgsql-general@postgresql.org
>
> On Fri, Jun 25
Dave Page writes:
> Hmm, I think I misread Thom's question. The smgr API used to be far
> more rigidly designed as I understand it, to allow the possibility of
> having different storage engines (for example, maybe one that used raw
> devices). I don't know that any other storage engines were ever
Thank you all for the responses. I got a requirement from my boss that I
need to give read only access to only tables , so that users can write some
queries. At that time, he also mentioned that the users should not see the
code. I read the document , but not able to figure out how to do that and
t
Thomas Kellerer, 25.06.2010 14:32:
Wang, Mary Y, 25.06.2010 01:04:
Hi,
I'm trying to find some write-ups about the differences between Postgres
and MySql. A lot of stuff showed up on Google, but most of them are old.
I saw this wiki over here
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instea
On Fri, Jun 25, 2010 at 6:58 AM, Scott Marlowe wrote:
>
> Biggest difference between MySQL and PostgreSQL? The developers.
>
>
I like that... It has a nice ring to it.
Hello!
I have user-defined procedure (C procedure) realised in dll
('c_some_text_dll'). It is called in the following way:
1. CREATE OR REPLACE FUNCTION "app_text" () RETURNS text AS
'$libdir/c_some_text_dll', 'getTextValueFromApplication'
LANGUAGE 'c' VOLATILE RETURNS NULL ON NULL INPUT SECURITY
Wang, Mary Y, 25.06.2010 01:04:
Hi,
I'm trying to find some write-ups about the differences between Postgres
and MySql. A lot of stuff showed up on Google, but most of them are old.
I saw this wiki over here
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 and
plan to watch a
On Fri, Jun 25, 2010 at 7:58 AM, Scott Marlowe wrote:
> This shows several things about the MySQL release philosophy, at least
> at the time. 1: Introducing performance enhancments without thorough
> testing in a production release is A-OK. 2: The fix may or may not
> actually work when it does
On 25 Jun 2010, at 10:54, Dick Kniep wrote:
> Hi List,
>
> Thanks for this great product.
>
> We have a database with many schema's and we are trying to migrate the db
> from version 8.1.9 to 8.3.8.
>
> So we made a pg_dumpall.
Using which version? The one that came with 8.3? I'm suspectin
On Fri, Jun 25, 2010 at 4:22 AM, John Gage wrote:
> There are features, are there not, that Postgres has that MySQL does not
> have?
My favorite pgsql feature is partial and functional indexes. For
instance, let's say you have a work queue, and in it you have a boole
called processed. it is 99.
Disabused.
On Jun 25, 2010, at 11:59 AM, Thomas Kellerer wrote:
Getting really off-topic now: but MySQL does support Regex
http://dev.mysql.com/doc/refman/5.1/en/regexp.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://
John Gage, 25.06.2010 11:50:
Replying to my own post, and on further examination of the MySQL
documentation, I am astonished to discover that MySQL does not support
regular expressions much less something like tsvector. Please disabuse
me of this idea if I am mistaken.
Getting really off-topic
On 25 June 2010 10:50, John Gage wrote:
> In the words of Dwight Eisenhower, I couldn't fail to disagree with you
> less. That said...
>
> Replying to my own post, and on further examination of the MySQL
> documentation, I am astonished to discover that MySQL does not support
> regular expression
In the words of Dwight Eisenhower, I couldn't fail to disagree with
you less. That said...
Replying to my own post, and on further examination of the MySQL
documentation, I am astonished to discover that MySQL does not support
regular expressions much less something like tsvector. Please
On Fri, Jun 25, 2010 at 10:22 AM, A. Kretschmer
wrote:
> In response to Dave Page :
>> On Fri, Jun 25, 2010 at 9:52 AM, Thom Brown wrote:
>>
>> > Didn't PostgreSQL used to have more than 1 storage engine in the past?
>> > I thought I read somewhere it did, but it was decided it was a
>> > compro
In response to John Gage :
> Forgive me for being somewhat stupid, but is MyISAM a text search
> engine? The Wikipedia article doesn't make it sound like one.
MyISAM provides textsearch and other features, but no referential
integrity. It's just one of many storage engines.
>
> Could you be m
Hi List,
Thanks for this great product.
We have a database with many schema's and we are trying to migrate the db from
version 8.1.9 to 8.3.8.
So we made a pg_dumpall.
Now, when we try to restore with psql, we get loads of errors and warnings:
PROBLEM 1
psql:db03.ak1.sql:101
In response to Dave Page :
> On Fri, Jun 25, 2010 at 9:52 AM, Thom Brown wrote:
>
> > Didn't PostgreSQL used to have more than 1 storage engine in the past?
> > I thought I read somewhere it did, but it was decided it was a
> > compromise on stability and/or quality, so ended up using a single
>
Forgive me for being somewhat stupid, but is MyISAM a text search
engine? The Wikipedia article doesn't make it sound like one.
Could you be more specific as to how, for example, MySQL implements
regular expressions or the tsvector funcitionality?
John
On Jun 25, 2010, at 10:33 AM, Rob W
On Fri, Jun 25, 2010 at 9:52 AM, Thom Brown wrote:
> Didn't PostgreSQL used to have more than 1 storage engine in the past?
> I thought I read somewhere it did, but it was decided it was a
> compromise on stability and/or quality, so ended up using a single
> kick-ass engine?
Yes, many, many mo
On 25 June 2010 09:44, Dave Page wrote:
> On Fri, Jun 25, 2010 at 9:33 AM, Rob Wultsch wrote:
>> MySQL has several full text search solutions. The built in MyISAM
>> solution is the best known, but there is also an engine for using
>> sphinx.
>>
>> ...
>>
>> And there are features that MySQL has
On Fri, Jun 25, 2010 at 9:33 AM, Rob Wultsch wrote:
> MySQL has several full text search solutions. The built in MyISAM
> solution is the best known, but there is also an engine for using
> sphinx.
>
> ...
>
> And there are features that MySQL has that PG does not. Index only
> queries is a massiv
On Fri, Jun 25, 2010 at 1:22 AM, John Gage wrote:
> There are features, are there not, that Postgres has that MySQL does not
> have?
>
> I refer in particular to things like tsvector.
>
> Am I mistaken in this?
>
> John
>
>
> On Jun 25, 2010, at 3:46 AM, Rob Wultsch wrote:
>
>> unless there was a
There are features, are there not, that Postgres has that MySQL does
not have?
I refer in particular to things like tsvector.
Am I mistaken in this?
John
On Jun 25, 2010, at 3:46 AM, Rob Wultsch wrote:
unless there was a specific reason to migrate
--
Sent via pgsql-general mailing list
On Fri, Jun 25, 2010 at 12:04 AM, Wang, Mary Y wrote:
> Hi,
>
> I'm trying to find some write-ups about the differences between Postgres and
> MySql. A lot of stuff showed up on Google, but most of them are old.
> I saw this wiki over here
> http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_
On Friday 25 June 2010 02:23:17 Iwao Shikase wrote:
> Hi Roeleveld-san,
>
> Thank you for your advice. But My purpose is to test PostgreSQL
> which data cluster is in NFS server.
> As your says, Cluster Filesystem is one of answer of sharing files.
> But my company still want to use NFS server. S
65 matches
Mail list logo
