Dear all,
2 days ago, I need to backup 2 databases in my Database server because I
need to format the system and reinstalls again with the back up databases.
After a fresh install of ubuntu-10.4 , I install postgreplus-8.4 binary
and I think giving the previous data directory
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Srikanth,
hae a look at this thread:
http://bytes.com/topic/postgresql/answers/627208-problem-windows-postgresql-8-1-service
Most probably the cause on your computer is different, but you can get
some ideas about where to find log files and how
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, Mar 21, 2011 at 11:43:57AM +0530, Adarsh Sharma wrote:
Dear all,
2 days ago, I need to backup 2 databases in my Database server because I
need to format the system and reinstalls again with the back up databases.
After a fresh install
On Mar 21, 2011, at 11:43 AM, Adarsh Sharma wrote:
But what I have noticed that there is 6 databases in my Postgres database and
one database pdc_uima doesn't have any entry in \l command.
However I restore it from my previous backup.
That should not happen. If the Binaries version is
On Mar 21, 2011, at 10:42 AM, preetika tyagi wrote:
Query: INSERT INTO table1 SELECT * FROM table2.
Execution Time: A ms.
Query: INSERT INTO table1 SELECT * FROM table2.
Execution Time: B ms
If session is same, then
B A if the data is cached due to execution of first statement.
B A, if
Dear Everybody!
We need to choice a DB for our new project.
Two of the databases are possible to choose.
1.) PGSQL 9.x
2.) FireBird 2.x
We needs to serve 75/80 users in a time.
The client platform is Windows, Delphi based applications with [Zeos/PGDAC]
or [IBX/ZEOS].
The server is may Windows,
Hi!
Many databases (like Firebird) have some time limitation for the clients.
These cases possible with client:
a.) It is working, but network connection is temp. down.
b.) The client is crashing
c.) The client is on, but it is not working for N minutes.
When the server experience that client
--- On Mon, 3/21/11, basobdutta kar basobdutta_...@yahoo.com wrote:
From: basobdutta kar basobdutta_...@yahoo.com
Subject: Fw: slony- No index found
To: pgsql-general@postgresql.org
Date: Monday, March 21, 2011, 3:02 PM
--- On Mon, 3/21/11, basobdutta kar basobdutta_...@yahoo.com wrote:
--- On Mon, 3/21/11, basobdutta kar basobdutta_...@yahoo.com wrote:
From: basobdutta kar basobdutta_...@yahoo.com
Subject: slony- No index found
To: pgsqlgene...@postgresql.org
Date: Monday, March 21, 2011, 3:01 PM
Sir/Madam,
I have two databases- db1 and db2
db1 is the master and db2
On Sunday, March 20, 2011 11:13:57 pm Adarsh Sharma wrote:
Dear all,
2 days ago, I need to backup 2 databases in my Database server because I
need to format the system and reinstalls again with the back up databases.
After a fresh install of ubuntu-10.4 , I install postgreplus-8.4 binary
Thank you, Vibhor!
I am wondering if caching will make such a big difference. For example, if A
is 15 minutes, then B is 1.5 hrs.
What could be other factors in case database server is separated from
clients (on different computer systems)?
Preetika
On Mon, Mar 21, 2011 at 2:48 AM, Vibhor Kumar
On Mar 21, 2011, at 9:55 AM, preetika tyagi wrote:
For example, if A is 15 minutes, then B is 1.5 hrs.
Well, considering that random disk access is on the order of 10,000 times
slower than RAM...
But you can answer the question yourself by comparing the query run against
cold caches (after
Incredible! Setting enable_nestloop off temporarily for the run of this
script made it run in less than a minute (had been running in 10 or 11
minutes). I think you have found a solution for many of my slow running
scripts that use these same type of joins. Thanks again.
Julie
Nice. Can
The schemas in the two database must be *identical*. there are specific
things you can let be different, but if you are just starting out, don't try
to do that. also, there is a slony mailing list where the experts hang out.
On Mon, Mar 21, 2011 at 5:33 AM, basobdutta kar
On Mon, Mar 21, 2011 at 11:32 AM, t...@fuzzy.cz wrote:
Incredible! Setting enable_nestloop off temporarily for the run of this
script made it run in less than a minute (had been running in 10 or 11
minutes). I think you have found a solution for many of my slow running
scripts that use
Dear all,
2 days ago, I need to backup 2 databases in my Database server because I need
to format the system and reinstalls again with the back up databases.
After a fresh install of ubuntu-10.4 , I install postgreplus-8.4 binary and I
think giving the previous data directory
On Mon, Mar 21, 2011 at 11:32 AM, t...@fuzzy.cz wrote:
Incredible! Setting enable_nestloop off temporarily for the run of
this
script made it run in less than a minute (had been running in 10 or 11
minutes). I think you have found a solution for many of my slow
running
scripts that use
Hi,
Is there any way for a SQL or PL/pgSQL function to receive a table
as parameter? As an illustration, consider the dummy example below.
Note that functions get_from_data1 and get_from_data2 follow essentially
the same pattern; it would be nice to define instead a single polymorphic
am i the only one thinking that postgres is seriously lacking
recordings from conferences?
when i look at talks schedule from some postgres conference i always
wonder why nobody records talks?
i've heard arguments before, for other projects/conferences, that
authors/companies don't allow
Thank you, Scott!
I tried running the same query after reboot and back-to-back, it was taking
less time in both the cases. It means the problem is something else.
Can there be a reason which is more hardware/operating system specific and
due to which the behavior is not uniform?
Preetika
On
On Mon, Mar 21, 2011 at 10:30 AM, Vick Khera vi...@khera.org wrote:
The schemas in the two database must be *identical*. there are specific
things you can let be different, but if you are just starting out, don't try
to do that. also, there is a slony mailing list where the experts hang
Hello
2011/3/21 Jon Smark jon.sm...@yahoo.com:
Hi,
Is there any way for a SQL or PL/pgSQL function to receive a table
as parameter? As an illustration, consider the dummy example below.
Note that functions get_from_data1 and get_from_data2 follow essentially
the same pattern; it would be
On Mon, Mar 21, 2011 at 1:45 PM, Aljoša Mohorović
aljosa.mohoro...@gmail.com wrote:
postgres is losing a lot of promotional and educational materials, why
is this happening?
Someone has to do lots of work to tape the talks, get proper
permissions from the presenters, and then host the videos.
On Mar 21, 2011, at 11:13 PM, Jon Smark wrote:
Is there any way for a SQL or PL/pgSQL function to receive a table
as parameter? As an illustration, consider the dummy example below.
Note that functions get_from_data1 and get_from_data2 follow essentially
the same pattern; it would be
2011/3/21 Vibhor Kumar vibhor.ku...@enterprisedb.com:
On Mar 21, 2011, at 11:13 PM, Jon Smark wrote:
Is there any way for a SQL or PL/pgSQL function to receive a table
as parameter? As an illustration, consider the dummy example below.
Note that functions get_from_data1 and get_from_data2
On Mon, Mar 21, 2011 at 8:23 PM, Vick Khera vi...@khera.org wrote:
Someone has to do lots of work to tape the talks, get proper
permissions from the presenters, and then host the videos. Often this
would land on the shoulders of the conference organizers, who are
already working hard just to
On Mar 22, 2011, at 1:32 AM, Pavel Stehule wrote:
it can work too, but there is sql injection risk.
Do newer 'SELECT ... FROM ' || tabname || ' ...
Regards
Pavel Stehule
Yes true. Same with the following too:
CREATE FUNCTION foo(tablename text)
RETURNS SETOF text AS $$
BEGIN
RETURN
It seems that I don't get the postgresql server installed or available
for me to run in admin tools then services. postgresql is not listed as
a service available to start or stop!
Why do I not get the service installed and running?
--
Sent via pgsql-general mailing list
Incredible! Setting enable_nestloop off temporarily for the run of this script
made it run in less than a minute (had been running in 10 or 11 minutes). I
think you have found a solution for many of my slow running scripts that use
these same type of joins. Thanks again.
Julie
2011/3/21 Vibhor Kumar vibhor.ku...@enterprisedb.com:
On Mar 22, 2011, at 1:32 AM, Pavel Stehule wrote:
it can work too, but there is sql injection risk.
Do newer 'SELECT ... FROM ' || tabname || ' ...
Regards
Pavel Stehule
Yes true. Same with the following too:
CREATE FUNCTION
On Mar 21, 2011, at 12:03 PM, preetika tyagi wrote:
I tried running the same query after reboot and back-to-back, it was taking
less time in both the cases. It means the problem is something else.
Can there be a reason which is more hardware/operating system specific and
due to which the
On Mon, Mar 21, 2011 at 09:09:35PM +0100, Aljoša Mohorović wrote:
On Mon, Mar 21, 2011 at 8:23 PM, Vick Khera vi...@khera.org wrote:
Someone has to do lots of work to tape the talks, get proper
permissions from the presenters, and then host the videos. Often this
would land on the
On Mar 22, 2011, at 1:52 AM, Pavel Stehule wrote:
simply thinks as using USAGE clause or functions quote_ident,
quote_literal are faster and absolutly secure :). Software like SQL
I don't think usage of quote_ident in current requirement of user, would
prevent sql injection.
Running sql
2011/3/21 Vibhor Kumar vibhor.ku...@enterprisedb.com:
On Mar 22, 2011, at 1:52 AM, Pavel Stehule wrote:
simply thinks as using USAGE clause or functions quote_ident,
quote_literal are faster and absolutly secure :). Software like SQL
I don't think usage of quote_ident in current requirement
On 22 March 2011 08:54, Alex wsopsta...@gmail.com wrote:
It seems that I don't get the postgresql server installed or available for
me to run in admin tools then services. postgresql is not listed as a
service available to start or stop!
Why do I not get the service installed and running?
On Mon, Mar 21, 2011 at 9:45 PM, David Fetter da...@fetter.org wrote:
Who proposes, volunteers! How are you going to help?
being on a different continent and unable to attend doesn't actually
enable me to do something.
my post doesn't try to undermine actual work being done by people on
Try this :
1) rewrite your query as is :
select course_id AS EXTERNAL_COURSE_KEY,
user_id AS EXTERNAL_PERSON_KEY,
'Student' AS ROLE,
'Y' AS AVAILABLE_IND
from course_user_link AS CUL
INNER JOIN course_control AS CC
ON CUL.course_id = CC.course_id
where
On Mon, Mar 21, 2011 at 11:55:20PM +0100, Aljoša Mohorović wrote:
On Mon, Mar 21, 2011 at 9:45 PM, David Fetter da...@fetter.org wrote:
Who proposes, volunteers! How are you going to help?
being on a different continent and unable to attend doesn't actually
enable me to do something.
Not
On Tue, Mar 22, 2011 at 12:20 AM, David Fetter da...@fetter.org wrote:
Not so, by a long shot. If this is actually important to you, there
are plenty of ways you could help, not least by funding the effort.
[...]
What you really, really need to stop doing is proposing that others do
an
Dne 21.3.2011 20:23, Vick Khera napsal(a):
On Mon, Mar 21, 2011 at 1:45 PM, Aljoša Mohorović
aljosa.mohoro...@gmail.com wrote:
postgres is losing a lot of promotional and educational materials, why
is this happening?
Someone has to do lots of work to tape the talks, get proper
permissions
Dne 21.3.2011 21:45, David Fetter napsal(a):
Who proposes, volunteers! How are you going to help?
Well, if this is the only problem then I happily volunteer to take care
of this for pgday 2011.
regards
Tomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Using Postgres 9.0.3 on Solaris 10 (Sparc). I have a few questions concerning
hot backups with continuous archiving. We have read and think we understand
the Postgres documentation on backup and restore located here:
http://www.postgresql.org/docs/9.0/static/continuous-archiving.html
We
Dne 22.3.2011 00:20, David Fetter napsal(a):
On Mon, Mar 21, 2011 at 11:55:20PM +0100, Aljoša Mohorović wrote:
On Mon, Mar 21, 2011 at 9:45 PM, David Fetter da...@fetter.org wrote:
Who proposes, volunteers! How are you going to help?
being on a different continent and unable to attend
On 03/21/11 5:04 PM, Tomas Vondra wrote:
So just put there a tripod, a reasonable HD cam for $300 and you'll get
a decent video of the session.
you definitely want a sound patch from a lapel mic or the room PA, and
not be using on-camera sound.
and probably two cameras, one aimed at the
On Mon, Mar 21, 2011 at 7:16 PM, John R Pierce pie...@hogranch.com wrote:
On 03/21/11 5:04 PM, Tomas Vondra wrote:
So just put there a tripod, a reasonable HD cam for $300 and you'll get
a decent video of the session.
you definitely want a sound patch from a lapel mic or the room PA, and
On Fri, Mar 18, 2011 at 8:38 AM, Voils, Steven M st...@sensorswitch.comwrote:
What are the general guidelines under which autovacuum will trigger? I was
unaware it was turned on by default for the newer versions. Would it be
worthwhile to leave the manual vacuuming on? Currently it runs
On Fri, Mar 18, 2011 at 6:38 AM, Voils, Steven M st...@sensorswitch.com wrote:
What are the general guidelines under which autovacuum will trigger? I was
unaware it was turned on by default for the newer versions. Would it be
worthwhile to leave the manual vacuuming on? Currently it runs
47 matches
Mail list logo