Hi i want to convert mysql to postgresql ,
any free tools available?. Is it possible to convert manually. Please
guide me
best regards
Alfred
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
Hi
-am monitoring the postgresql9.2.4 using monit in my virtual
private server. Am always getting following log
2013-08-21 06:02:33 UTC LOG: incomplete startup packet
2013-08-21 06:04:33 UTC LOG: incomplete startup packet
2013-08-21 06:06:33 UTC LOG: incomplete startup packet
-why the
Hallo,
I'm using fedora 8 and I have problems to run 8.2 and 8.3 parallel on the same
computer . Is it realy necessary to run pg_dumpall with 8.3.
With kind regards
Alfred
Hi Jason,
Permssions was the exact problem. After disabling the simple file sharing
option in Folder Options (under Windows XP Professional), I was able to see
the permissions of the DATA folder and change them appropriately.
Gracias,
Alfred.
On Wed, 18 Jan 2006 11:26:26 -0600, Jason Minion
s possible.
I've verified that there is no .pid file in the DATA directory. Are
there
other files I am missing? Anything else I might try?
Thanks,
Alfred Lau
ible. I've verified
that there is no .pid file in the DATA directory. Are there other files I am
missing? Anything else I might try?
Thanks,
Alfred Lau
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
n option called '--pwd-from-stdin-only' would be a
solution. Another option (thanks God for Open Source projects) is adding
an option for prompting into psql by myself. But I see this is a rather
drastic measure to get what I need/want.
Thanks and greetings from the Su
er your answer sun came
from behind the clouds :)
More thanks and greetings from the Sunny side of the Alps.
Alfred Anzlovar
PS
Is it ok to send e-mail to [EMAIL PROTECTED] AND TO you?
---(end of broadcast)---
TIP 2: you can get off all lists at
ntroduces
many new problems (and does not solve any of security ones).
It would be nice if there was an option (in psql) to use stdin instead of
/dev/tty to read password(s) (like before 7.2.X).
Is this too much to ask?
Thanks,
Alfred
---(end of broadcast)
This Postgresql can't see by itself what is the difference ?
> I don't want to check every character, this is stupid. I'd rather change
> the RDBMS.
Most every interface into postgresql has a 'quoting' mechanism that
will escape these characters for you. Check
, only planning to serve it through local
> cable in Indian metro cities.
What about it? (the Beowolf cluster)
A Beowolf cluster doesn't suddenly allow Postgresql to run on
multiple machines whilke acting as a single entity, there's libraries
that Postgresql must be ported to use afaik.
-Alfred
aving to give up the cpu to
> allow other processes to run. With two cpu's, I believe one backend can
> camp out on a cpu forever as long as the other cpu doesn't get busy.
That's true, as long as there's no contention for the locks then it's
pretty cheap.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
an cause a lot of perf degredation(sp?) for the idle SMP case.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Jean-Arthur Silve <[EMAIL PROTECTED]> [001206 04:55] wrote:
> Thanks for your help
> pg_exec($dbh, "set enable_seqscan off;");
> seems resolve my problem...
>
> I look at the docs, but I didn't understand very well what is the use of
> this variable ?
run:
explain
with and without the opti
lyze " ?
2) do you have indecies on this table?
3) have you tried this: pg_exec($dbh, "set enable seqscan off;"); (*)
4) how can you expect help without going into a bit more detail about
how your table is set up and what the actuall query is?
(*) not sure on the syntax for that on
* Alfred Perlstein <[EMAIL PROTECTED]> [001123 15:04] wrote:
> * Alfred Perlstein <[EMAIL PROTECTED]> [001123 14:33] wrote:
> > * Timothy J Hitchens <[EMAIL PROTECTED]> [001123 13:35] wrote:
> > >
> > > That is 4 Million Queries per Second w
* Alfred Perlstein <[EMAIL PROTECTED]> [001123 14:33] wrote:
> * Timothy J Hitchens <[EMAIL PROTECTED]> [001123 13:35] wrote:
> >
> > That is 4 Million Queries per Second which is 14 Billion 400 Million per
> > hour.
> >
> > This may sound a little
on 400 Million per
> hour.
>
> This may sound a little big but this is what we will be launching on the 1st
> December 2000 using postgresql and php.
What platform is this going to be on? You will not be able to do
4 million queries per second with Postgresql on a PC platform.
--
-Alf
but I don't know it what way I can
> experiment with them?
>
> If somebody has some tips handy i'd like to hear them.
I have a gig of ram and use:
-B 32768
-o "-F -S 65534"
maybe if you halve those values...
you may also need to vacuum the database.
What OS are you running?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Hossein S. Zadeh <[EMAIL PROTECTED]> [001115 22:26] wrote:
> On Wed, 15 Nov 2000, Alfred Perlstein wrote:
>
> > * Serge Canizares <[EMAIL PROTECTED]> [001115 08:23] wrote:
> > >
> > > Of course, if someone sees a reason that RAID 5 would be bet
directory
>`/dmf/pkgs/postgres/7.0.3/postgresql-7.0.3/src/interfaces'
> gmake: *** [all] Error 2
>
Find 'ar' on your system, add it to your path.
-Alfred
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
l Pentium III 550Mhz with 256MB RAM.
My suggestion would be to try the latest version, 7.0.3, it's fixed
numerous bugs for us and performs a lot better. We used to have a
bunch of problems with 6.5.3 and upgrading to 7.0.2 solved a lot
of them, 7.0.3 solved the rest of the problems we've seen in 7.0.2.
best of luck,
-Alfred
* Serge Canizares <[EMAIL PROTECTED]> [001115 08:23] wrote:
>
> Of course, if someone sees a reason that RAID 5 would be better than RAID 1+0,
> I'd appreciate an explanation!
Cost. :)
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart o
big table in reality.
You are only limited to 2 gigabytes in Linux, I don't know of any
other modern unix with that limitation.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
ostgresql uses
with the -B option.
I'd go on but it wouldn't be worth the effort without hearing
what you've tried to do to get performance up.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Joel Pang <[EMAIL PROTECTED]> [001026 04:27] wrote:
> In psql, once I delete an entry, it's gone permanently. How do I disable
> such auto-commit behavior?
by beginning a transaction, just type:
"BEGIN;"
then with 'COMMIT;' (to commit) or 'ROLLBA
do a 'vacuum analyze' on the tables and
make sure you have proper indexing.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Gavin M. Roy <[EMAIL PROTECTED]> [001024 13:12] wrote:
> Am looking here:
> http://www.postgresql.org/devel-corner/docs/admin/runtime-config.htm
>
> but not seeing anything on shared memory. Do you know the configuration
> option for this?
-B
>
> Gavin
to stdout and not to pgserver.log (as I
> would want it).
You need to read your shell's manpage, try:
nohup postmaster -i >& pgserver.log &
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
# truncate/ftruncate routine
# or simply : cat /dev/null > logfile (my work)
killall -CONT postresql
you shouldn't loose any data that way.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
the file and the server will still have
an open reference to it and the space won't be reclaimed.
-Alfred
stgresql needs some utility to do this, I may whip one up when
time allows, it should be trivial.
-Alfred
ating system's amount of
semaphores, check your OS's documentation for hints on how to do so
or ask your support representative.
-Alfred
33 matches
Mail list logo
