I want to
rename and modify the data type of a column in
postgres 7.3 can any body help me ...that it is possible to do the above in
postgres and if yes pls provide me the syntax
thanx in advance
Disclaimer :- This e-mail message including any attachment may contain confidential, prop
On Fri, 2005-04-01 at 01:29 +0100, Simon Riggs wrote:
> I'm considering options for the next release, since major change seems
> to be required to the basic xlog handling mechanisms.
Hmmm. I've thought about what to do here, I'll detail a proposal on
HACKERS over next few days. If I'm right it wil
On Thu, 2005-03-31 at 23:46 -0500, Jason DiCioccio wrote:
> Simon,
>
> On Mar 31, 2005 7:29 PM, Simon Riggs <[EMAIL PROTECTED]> wrote:
> >
> > In retrospect, there is a slight timing error between end backup and
> > archival of next WAL log. The first-release design for PITR didn't fully
> > cove
Simon,
On Mar 31, 2005 7:29 PM, Simon Riggs <[EMAIL PROTECTED]> wrote:
>
> In retrospect, there is a slight timing error between end backup and
> archival of next WAL log. The first-release design for PITR didn't fully
> cover lower traffic situations, so in those cases the timing error
> becomes
I donno why, but it is libpq.dll which hampered the installation, I
copied libpq.dll into system32 folder when I installed mapserver, now
I just renamed it to a different name and the installation was
successful and postgres installed a new libpq.dll file, I donno if
this causes any problems to map
On Thu, 2005-03-31 at 18:41 -0500, Jason DiCioccio wrote:
> Now, realize that ..0022 was not in the archive directory, and
> actually is still not. However, it seems to be requiring it. Do I
> have to wait for this log to be archived?
Yes.
> Is there a way that I can
> force the archival o
I have written the following query that ties together locks with databases and users, but I cannot determine from the columns in each of the views used how to associate this data with objects (tables, views, rows) in the Postgres database:-
select relation, transaction, pid, mode, granted, datname
Greetings,
I am having some trouble figuring out exactly what I'm supposed to
be doing to successfully recover from an online backup. I am not in a
critical situation or anything, simply doing some testing to make sure
that my backup system would work. Here's the problem:
I do a 'SELECT pg_s
--
***
Alexánder Cadavid Giraldo
Linux Registered User 247293
Grupo de Usuarios GNU/LInux de Pereira
PULPA
Pereira, Risaralda, Colombia
---(end of broadcast)---
TIP 5: H
Steve Crawford wrote:
On Monday 21 March 2005 11:40 am, Tom Lane wrote:
"Matthew T. O'Connor" writes:
I believe this discrepancy has to do with the fact that ANALYZE
can return some very bogus values for reltuples, where as vacuum
always returns an accurate count. I'm not sure how to best
HI Martin,
Thanks for your response. I tried installing from postgresql user
account, it didn't worked for me. It was giving a different error
(Access Denied), I gave all security permissions to that user still it
didn't worked. This user is not a power user (only limited user) but i
didn't see any
I just spent some time with Verizon and we will see if they can fix, or if I
have to find a new provider.
I will try that prior to point to point (although the point to point may be
a good option too if all else fails).
Thanks everyone for the ideas and helping get a clear perspective on the
issue.
On Thu, Mar 31, 2005 at 12:06:11PM +0200, Zouari Fourat wrote:
>
> anyone can help me with a sample of pg_hba.conf
See the "Client Authentication" chapter in the documentation. Here's
a link to the latest version (use a different link if you're using
an older version of PostgreSQL):
http://www.p
On Monday 21 March 2005 11:40 am, Tom Lane wrote:
> "Matthew T. O'Connor" writes:
> > I believe this discrepancy has to do with the fact that ANALYZE
> > can return some very bogus values for reltuples, where as vacuum
> > always returns an accurate count. I'm not sure how to best
> > handle this
On Thu, Mar 31, 2005 at 10:11:53 +0200,
Morus Walter <[EMAIL PROTECTED]> wrote:
>
> What comes in my mind regarding DSL is that a common error is to use
> a too large MTU. Since there is some repackaging of network packets in
> the ppp over ethernet protocol, one needs to make sure that the raw
Am Donnerstag, 31. März 2005 16:12 schrieb Tsirkin Evgeny:
> The question is how it will behave will this eraise an error or it will
> just not sork correctly?
That depends entirely on your operating system's C library.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
--
On Thu, 2005-03-31 at 08:00, Joel Fradkin wrote:
> Well the issue seems to occur for any traffic not limited to any one
> machine.
>
> Pinging Yahoo for instance the ping is timing out when the line gets full
> load.
> I spoke to Verizon and they admitted they sold more bandwidth then the hard
> w
On Thu, 2005-03-31 at 02:52, [EMAIL PROTECTED] wrote:
> Zitat von Chris Browne <[EMAIL PROTECTED]>:
>
> > [EMAIL PROTECTED] writes:
> > > i would like to know if there is something like the Oracle "shared
> > > server" possible with PostgreSQL. I have searched the archives but
> > > have not found
Peter Eisentraut wrote:
Am Donnerstag, 31. März 2005 15:49 schrieb Tsirkin Evgeny:
Is there any relation between the locale and character set?
Every locale expects a certain character set to be used. You can find that
out using
$ LC_ALL=foo locale charmap
If you want things to function c
Well the issue seems to occur for any traffic not limited to any one
machine.
Pinging Yahoo for instance the ping is timing out when the line gets full
load.
I spoke to Verizon and they admitted they sold more bandwidth then the hard
wires in the area support.
I am going to see if we can slow dow
Am Donnerstag, 31. März 2005 15:49 schrieb Tsirkin Evgeny:
> Is there any relation between the locale and character set?
Every locale expects a certain character set to be used. You can find that
out using
$ LC_ALL=foo locale charmap
If you want things to function correctly, you have to use a
Hi list!
Is there any relation between the locale and character set?
For example if i store the data as sql_ascii can i still use the locale
as utf-8?
In my case i have the data stored as ascii but i just know it is
actually utf-8 and i am doing upgrade ,
So i would like to leave the ascii as int
anyone can help me with a sample of pg_hba.conf
On Wed, 30 Mar 2005 09:47:31 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Wed, Mar 30, 2005 at 11:14:38AM -0500, John DeSoi wrote:
> > On Mar 30, 2005, at 10:17 AM, Zouari Fourat wrote:
> >
> > >is it really secure in a shared hosting environ
Zitat von Chris Browne <[EMAIL PROTECTED]>:
> [EMAIL PROTECTED] writes:
> > i would like to know if there is something like the Oracle "shared
> > server" possible with PostgreSQL. I have searched the archives but
> > have not found any real discussion regarding this.
> >
> > We have two CTI appli
Joel Fradkin writes:
> Hi,
>
>
>
> We are in development stage of implementing postgres.
>
> Our data center is in Tampa and we are in Bardenton and I am using DSL at my
> office (384 up, 1.5 down).
>
> Data center is 2 meg ea way.
>
> When I use pgadmin to connect it is ok, but as soon as I
25 matches
Mail list logo
