g out and back in again when
using the GUI editors, and if you changed it from the commandline it
might simply be gone.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
s running pg in a virtual machine on the
box.
> It'd be interesting if someone with a paid contract for AV support would
> go to their AV vendor and get them involved. With the active
> co-operation of an AV vendor or two and a reproducible fault, some
> progress might be possible.
On Mon, Jun 7, 2010 at 15:58, Thomas Kellerer wrote:
> Magnus Hagander, 07.06.2010 15:52:
>>>
>>> Some AV software probably behaves fine.
>>
>> Probably.
>
> In case anyone is interested:
>
> I have two development computers that run Postgres on Windo
"mapped win32 error code to " showing
up - there will be *tons* of other logging output of course)
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
re out when that gets
set.
> Anybody ever seen this?
Well, at the risk of sounding like a broken clock, yes - with
antivirus or antispyware that sets the flag on things they find
suspicious.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via
On Mon, Jun 14, 2010 at 10:57, Scott Marlowe wrote:
> On Mon, Jun 14, 2010 at 2:35 AM, Magnus Hagander wrote:
>> On Mon, Jun 14, 2010 at 05:17, John T. Dow wrote:
>>> Apparently the problem boils down to this question: how did some of the
>>> files get set to be syst
ons available for
the windows installers, but you can always download the source off the
postgresql.org mirrors and build your own binaries.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
ventually get finished.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
l probably need to find a non-US company for that, but there
are plenty of those around both in Europe and elsewhere. Only the
installer is the issue there.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-genera
n, there are usually backports available of the newer
versions.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
g about the features also included in PostgreSQL,
you should start by reading the chapters at
http://www.postgresql.org/docs/8.4/static/backup.html.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@po
ostgreSQL builds isn't - it "should just work", but I don't
believe anybody has ever tried it. But this error shows a much more
fundamental problem than the PostgreSQL code, and you need to get that
solved first.
Any particular reason why you don't want to build with the
7;t been worked on in a while, but is this any
> use?: http://nagiosplugins.projects.postgresql.org/
Those are plugins to monitor postgresql using nagios. For that, you
should realy be looking at check_postgres. I think what the OP is
looking for is a way to store Nagios metadata in postgres, w
d the child will stop working.
In theory you could do something like close(PQsocket(conn))...
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
dependent.
> also, once the target PG database receives WAL files and update its own
> database, can I run pg_dump to dump all the data when it is in recovery
> mode?
No.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-ge
cation again from scratch,
meaning from a new base backup. That also means that if the master
crashes while you're backing up your slave, it will be out of date.
> Will it break the relationship between source and target? Do I need to
> re-configure it in order to receive the WAL files?
Ye
is here, or what
> additional things I can do to get more information out next time the backend
> crashes?
>
> I'm running PostgreSQL 8.4.4 on Windows server 2003 Standard.
Are there any running postgres.exe processes still present on the
machine? (Other than the postmaster itself, that is
k_mem = 191845
>> max_stack_depth = 2MB
>
> 1GB for temp_buffers is a *LOT*. You do realize that's per backend?
> Those other settings don't look too unreasonable.
Definitely - particularly since this is a 32-bit version, that's
getting very close to the address spac
ons), I would encourage you to look at setting up a mirror on
github and use their wiki services.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
saction and never commits it. Perhaps the previous version
was working in autocommit mode by default, and the new one doesn't.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I tried with shared_buffers > 4Gb, but now that i see that page,
I think I need to re-verify that :-)
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
d windows import libraries, so you need to create your own
there)
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
)
>
> Magnus how can I linking against postgres.exe I mean the gcc line. I did
> others function and worked fine
Sorry, I don't know this. I don't use mingw myself anymore. But it
should work in the same way as you link against any other third-party
DLLs with it - DLLs and
*within* the
server or *within* the client will make things a lot harder.
Also note that PostgreSQL 9.0 will be available natively 64-bit on Windows.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-gene
gAgent for this. It ships with pgAdmin3 (and as a
separate download) and can do all this.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
4 bit versions of Windows can it run?
Any x64 version should work fine. No support for Itanium if you happen
to have one of those old versions.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgre
ped the pgxs file - for users of mingw? I have a feeling it won't
- the thing uses files generated by the postgresql ./configure-script,
doesn't it?
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
oral extensions. IIRC it's a very simple project. Jeff - have you
looked at this?
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, since the
view can only talk to one database at a time.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
here's a way to access that function through psycopg2.
But it does outline that fact that it wouldn't suck to have a function
in libpq returning the version so that application can check this at
runtime - clearly it would also be useful when being linked "through"
somethi
t;= 9) {
>
> I'd raise a bug with psycopg2 if it does not provide that information.
How does the driver figure it out?
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
t's even present at all.
>
> We could add a PQlibpqVersion(), maybe, but it would be many years
> before client code could rely on that being present.
I think we should.
And in a small way they can already - if they check for it
dynamically, they'll know if it was 9.1 or newer at
versions of
libpq that may be installed on the machine you are actually linking
against?
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ir and pg_config --includedir.
But that's build-time, not run-time.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
of DBD::Pg clearly doesn't tell you what
version of libpq it's using, only what it was built against.
As long as you have libpq 9.0, you can decode the bytea hex thingy,
irregardless of what version of libpq your was linked against.
--
Magnus Hagander
Me: http://www.hagander.net
On Wed, Oct 6, 2010 at 15:54, Tom Lane wrote:
> Magnus Hagander writes:
>> On Wed, Oct 6, 2010 at 14:17, Greg Sabino Mullane wrote:
>>>> But that's build-time, not run-time.
>>>
>>> Correct, not sure of your point. Is this a problem? Build-time is
>
management integration etc.
BTW - Dave, I notice the edb page says only ubuntu 8.04 and up, fedora
10 and up, etc are supported by the installers from 9.0 and newer -
the download page on pg.org should probably be updated with that
information.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Tom Lane wrote:
> "Roberts, Jon" <[EMAIL PROTECTED]> writes:
>> Version: "PostgreSQL 8.3.0, compiled by Visual C++ build 1400"
>
> Well, there are plenty of known bugs in 8.3.0 by now. You really
> should update before complaining, not after.
Yes. And the traditional question should be asked - i
Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
>> Tom Lane wrote:
>>> Another problem is that postmaster children that do
>>> PGSharedMemoryDetach will still have valid inherited handles for
>>> the shmem segment --- does that factor into
Richard Huxton wrote:
> Bjørn T Johansen wrote:
>> What does this mean and how can it be fixed? We are running Hibernate
>> with PostgreSQL 8.3.x...
>
> What query is Hibernate generating? That's an error from the planner.
It does sound like you're trying to query back more than 1664 columns in
Roberts, Jon wrote:
>> Tom Lane wrote:
>>> "Roberts, Jon" <[EMAIL PROTECTED]> writes:
Version: "PostgreSQL 8.3.0, compiled by Visual C++ build 1400"
>>> Well, there are plenty of known bugs in 8.3.0 by now. You really
>>> should update before complaining, not after.
>> Yes. And the traditiona
Roberts, Jon wrote:
>> Roberts, Jon wrote:
Tom Lane wrote:
> "Roberts, Jon" <[EMAIL PROTECTED]> writes:
>> Version: "PostgreSQL 8.3.0, compiled by Visual C++ build 1400"
> Well, there are plenty of known bugs in 8.3.0 by now. You really
> should update before complaining, not
Roberts, Jon wrote:
>> Not having looked at the internals of db_link, I'd say it's certainly
>> possible that this is the reason for the failed restart. If db_link is
>> blocking something, the postmaster can't kill it off, and it'll still
> be
>> sitting there holding a reference to the shared mem
Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
>> Not likely, but I'd test it anyway. If the issue is related to AV, it's
>> certainly fine - you won't be running AV on your Solaris. But more
>> importantly, Unix has actual support for sign
David R Robison wrote:
> I have an LDAP directory that contains contact information and a
> PostgreSQL table that has contact names. What I want to do is write a
> SELECT that will join the names in the table with the data in the LDAP
> directory (such as phone number, e-mail address, etc). Is this
xtension but no documentation on how to install
>> it or use it. Can you give me some pointers? TNX David
>>
>> Magnus Hagander wrote:
>>> David R Robison wrote:
>>>
>>>> I have an LDAP directory that contains contact information and a
>
Roberts, Jon wrote:
>> Roberts, Jon wrote:
Not having looked at the internals of db_link, I'd say it's
> certainly
possible that this is the reason for the failed restart. If db_link
> is
blocking something, the postmaster can't kill it off, and it'll
> still
>>> be
sitting ther
Rob Adams wrote:
> I'm trying to demonstrate recovery using the "continuous archiving"
> backup technique. I'm using 8.3 on Windows.
>
> I made a base backup while the postgres was running using the following
> batch file:
>
> --
> psql -d test_database -U user_name -c "S
[EMAIL PROTECTED] wrote:
> maybe i misworded my problem. i am looking for the possibility to install a
> psql client (without a server) out of the sources. my usecase is: one server
> with a postgresql-server (self compiled) and several workstations with
> psql-clients, also preferred self compi
Tom Tom wrote:
> Hello,
>
> We have a very strange problem when restoring a database on Windows XP.
> The PG version is 8.1.10
> The backup was made with the pg_dump on the same machine.
>
> pg_restore -F c -h localhost -p 5432 -U postgres -d "configV3" -v
> "c:\Share\POSTGRES.backup"
> pg_resto
ramamurthy kv wrote:
> Hi,
> Greetings!!!
>
> We have developed a software which uses PostgreSQL as one of the component.
> We would like to delever PostgreSQL along with our software as a single
> package. So we have to create an installer which installs PostgreSQL
> with all pre-install configur
Tom Tom wrote:
>> Tom Tom wrote:
>>> Hello,
>>>
>>> We have a very strange problem when restoring a database on Windows XP.
>>> The PG version is 8.1.10
>>> The backup was made with the pg_dump on the same machine.
>>>
>>> pg_restore -F c -h localhost -p 5432 -U postgres -d "configV3" -v
>> "c:\Sha
Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
>> I'll see if I can repro a case like it to see if the syslogger prevents
>> the shared mem from going away when I get back to a dev box. Should be
>> enough to just stick a sleep preventing it from sto
This is almost certainly the bug fixed in 8.2.4 and listed in the
release notes as:
"Allow pg_dump to do binary backups larger than two gigabytes on Windows
(Magnus) "
If it happens to be that your dump could approach the 2Gb limit, I
suggest you upgrade to 8.2.9 and see if it goes away.
As this
Tom Tom wrote:
> Magnus Hagander wrote:
>> Tom Tom wrote:
>>>> Tom Tom wrote:
>>>>> Hello,
>>>>>
>>>>> We have a very strange problem when restoring a database on Windows XP.
>>>>> The PG version is 8.1.10
>>&g
Kim Robinson wrote:
>
>
> Hi,
>
> I am using the npgsql postgres data adaptor in a C# ASP.NET application.
> Each time the site establishes a new connection to the database a
> postgres.exe process is started. For some reason this process is not
> removed when the connection is closed.
>
> Any
Tom Tom wrote:
> Magnus Hagander wrote
>> Tom Lane wrote:
>>> =?us-ascii?Q?Tom=20Tom?= <[EMAIL PROTECTED]> writes:
>>>> Magnus Hagander wrote:
>>>>> Attached is a pg_restore.exe off CVS tip today, which should include the
>>>>&g
>>> 2.Our production PG version is 8.1.3. For some reasons it is not possible to
>> upgrade to the LATEST;
>>> I tested the libpq also on this version and it worked. Is it OK? I mean, did
>> it worked by chance or the library
>>> API & contracts didn't change between this version and latest?
>> No
Phoenix Kiula wrote:
> On 8/26/08, Phoenix Kiula <[EMAIL PROTECTED]> wrote:
>> On 8/26/08, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>> >
>> > Slony replication lets postgresql accomplish this, which is really
>> > quite impressive. We just upgraded from an 8.1 server to an 8.3
>> > server v
Ow Mun Heng wrote:
> I posed this question to the Slony List as well, but no response yet.
It's actually in the Slony docs:
http://www.slony.info/documentation/partitioning.html
I haven't actually used it in production myself, though :-)
//Magnus
--
Sent via pgsql-general mailing list (pgsql-g
William Garrison wrote:
> I have just come to a horrible realization about PostgreSQL that I'm
> sure is supposed to be pre-requisite knowledge even going into this. So
> everyone may laugh at me now.
>
> We have a SAN volume, and we created a tablespace that that points to
> that SAN volume (Z:
Alvaro Herrera wrote:
> Russ Brown escribió:
>> Masis, Alexander (US SSA) wrote:
>>>"SELECT CURRVAL(
>>> pg_get_serial_sequence('my_tbl_name','id_col_name'));"
>> Any reason why you can't just do this?
>>
>> CREATE FUNCTION last_insert_id() RETURNS bigint AS $$
>> SELECT lastval();
>> $$ LANG
Ow Mun Heng wrote:
> Hi,
>
> I'm playing around with triggers to implement partitioning.
> I hit something which I don't know what and I don't have internet here
> at work to find out what is the cause.
>
>
> ERROR : stack depth limit exceeded
>
> I see that this is one of the options in postg
Ow Mun Heng wrote:
> On Fri, 2008-09-05 at 10:35 +0200, Magnus Hagander wrote:
>> Ow Mun Heng wrote:
>>> Hi,
>>>
>>> I'm playing around with triggers to implement partitioning.
>>> I hit something which I don't know what and I don't
Greg Smith wrote:
> On Mon, 8 Sep 2008, William Garrison wrote:
>
>> 2) We could install PostgreSQL onto the C: drive and then configure
>> the data folder to be on the SAN volume (Z:)
>
> Do that. You really don't want to get into the situation where you
> can't run anything related to the Post
Greg Smith wrote:
> On Tue, 9 Sep 2008, Magnus Hagander wrote:
>
>> As long as your SAN guarantees an atomic snapshot of all your data
>> (which every SAN I've ever heard of guarantees if you're on a single
>> volume - entry level SANs often don't have
Willy-Bas Loos wrote:
> Hi,
>
> Tablespaces are implemented as some sort of a hard link on windows, so
> that the data seem to be in the program files, but they're not.
No, they are implemented using softlinks, AKA NTFS Junctions.
> When i look at my C drive with spacemonger though, it tells me
The European PGDay 2008 is now open for registration. We are working on
finalizing the English schedule, but we already have an impressive list
of speakers available at http://www.pgday.org/en/speakers. The schedule
will have at least one English talk at all times, as well as a number of
Italian on
Daniel Futerman wrote:
> I'm trying to develop an automated PostgreSQL installer for Windows that
> uses a silent install of PostgreSQL and batch scripts to initialise the
> database cluster (i.e. run initdb) and start/stop the db server. The
> install shouldn't install as a service, so initdb need
On Thu, Oct 02, 2008 at 01:25:40PM +0100, Howard Cole wrote:
> Hello all,
>
> Does postgres 8.3.* work on Windows w2k8 x64? I could not find any
> reference to this on the website.
I think it does. It certaily works on w2k3 x64 and it should work on w2k8
on x86. I haven't heard a specific report
Markus Wanner wrote:
> Hi,
>
> Alvaro Herrera wrote:
>> If there are no backported packages for any given Postgres major
>> version, what will happen is that a lot of people will be forced to
>> build them from source, which is a lot worse. (There is a reason why
>> PGDG provides RPM for all majo
Mikkel Høgh wrote:
> On 14/10/2008, at 20.23, Daniel Verite wrote:
>> What I've noticed on drupal-6.4 with Ubuntu 8.04 is that the default
>> postgresql.conf has:
>> ssl=true
>> and since drupal doesn't allow connecting to pgsql with unix socket
>> paths [1], what you get by default is probably TCP
Jeff Davis wrote:
> It looks like there's no 64-bit version of postgresql for windows:
> http://swik.net/PostgreSQL/Planet+Postgresql/Magnus+Hagander:+PostgreSQL
> +vs+64-bit+windows
>
> but that the 32-bit version of postgresql works just fine on 32-bit or
> 64-bit windo
Dann Corbit wrote:
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:pgsql-general-
>> [EMAIL PROTECTED] On Behalf Of Magnus Hagander
>> Sent: Thursday, October 16, 2008 10:22 PM
>> To: Jeff Davis
>> Cc: pgsql-general@postgresql.org
>> S
On 31 okt 2008, at 02.18, Greg Smith <[EMAIL PROTECTED]> wrote:
On Thu, 30 Oct 2008, Tom Lane wrote:
The real reason not to put that functionality into core (or even
contrib) is that it's a stopgap kluge. What the people who want this
functionality *really* want is continuous (streaming) log-
Bruce Momjian wrote:
> Bruce Momjian wrote:
>> Alvaro Herrera wrote:
>>> Tom Lane escribi?:
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I don't know of a way to make MD5 and db_user_namespace work cleanly so
> we are considering removing db_user_namespace in 8.4.
We are? It's no
Taha Ozket wrote:
> Hi,
>
> I am using ldap for client authentication. I add a line to pg_hba.conf like
> this
>
> host allall192.168.1.104 255.255.255.0ldap
> "ldap://ldapserver:389/dc=domain,dc=com,dc=tr;;,sn=;?sub?(objectclass=*)"
>
> but It doesnt work. I dont want to use th
On 18 nov 2008, at 17.09, Pietro Tedesco
<[EMAIL PROTECTED]> wrote:
We have an instance of PostgreSQL on Windows 2003 with some
application
and our customer have asked for solution
24x7 without human intervention for problem on the hardware/software
primary instance.
Actualy there is a so
Magnus Hagander wrote:
> Tom Lane wrote:
>> Bruce Momjian <[EMAIL PROTECTED]> writes:
>>> Tom Lane wrote:
>>>> So, to a first approximation, the PG list traffic has been constant
>>>> since 2000. Not the result I expected.
>>> I also was
Alvaro Herrera wrote:
> Tony Caduto wrote:
>> Hi,
>> I am trying to compile my own copy of libpq.dll using bcc32.exe, the
>> docs say it is possible, but I get a error when it tries to compile
>> dirent.c
>
> How hard would it be to set up a buildfarm member that exercises the
> Borland compile
Dave Page wrote:
> On Sat, Nov 22, 2008 at 6:35 AM, David <[EMAIL PROTECTED]> wrote:
>> I am trying to use pgAdmin 1.8.4 to edit the pg_hba.conf file on a
>> PostgreSQL 8.3 database running on Ubuntu 8.10. I get the following
>> error message:
>>
>> An error has occurred:
>>
>> ERROR: absolute pa
Bruce Momjian wrote:
> Ron Mayer wrote:
>> Joshua D. Drake wrote:
>>> On Fri, 2008-11-21 at 08:18 -0800, Ron Mayer wrote:
Bruce Momjian wrote:
> Tom Lane wrote:
>> ... harder to keep
>> up with the list traffic; so something is happening that a simple
>> volume count doesn't ca
Glen Eustace wrote:
> Hi all,
>
> I was wondering whether anyone has had any experience running postgresql
> in a vm under ESx. VMware provides significant HA/DR oppurtunities and
> we would like to use it if we can. The DBase would be on a EMC SAN
> hosted LUN and the ESx servers would be dual
Bruce Momjian wrote:
> Magnus Hagander wrote:
>> Bruce Momjian wrote:
>>> Ron Mayer wrote:
>>>> Joshua D. Drake wrote:
>>>>> On Fri, 2008-11-21 at 08:18 -0800, Ron Mayer wrote:
>>>>>> Bruce Momjian wrote:
>>>>>>&g
Magnus Hagander wrote:
> Bruce Momjian wrote:
>> Magnus Hagander wrote:
>>> Bruce Momjian wrote:
>>>> Ron Mayer wrote:
>>>>> Joshua D. Drake wrote:
>>>>>> On Fri, 2008-11-21 at 08:18 -0800, Ron Mayer wrote:
>>>>>
Albe Laurenz wrote:
> Siddharth Shah wrote:
I am compiling postgres, I have some doubts on ./configure options
--disable-largefile
Does it refers to for storing blob objects to store or
anything else ?
>>> I couldn't find this configure switch in the documentatio
IPS wrote:
> Dear All,
> I am planning to migrate my database from Oracle 10g to Postgre SQL. The
> database in Oracle currently have about 21 million records and about 2
> million new record are getting added every month. I have few queries:
>
> a. I get the data from user in excel/csv file (ma
#x27;d
> be satisfied if it's fixed for 8.5 and beyond --- comments?
Seems like this would be a major PITA for packagers and end-user. And
it would be an issue for the vast majority of our users - who use
binary packages on whatever platform they're on. And that only to help
those t
ative psql 8.2 works, but I like to use newer psql = Win native
> psql.exe
>
> tested using Cygwin 1.5.x and 1.7.x
>
> Ssh tty problem using Windows native psql.exe ?
The native psql is written for Windows, not for Cygwin. You really
shouldn't be using it there... If you are us
t, as you've noticed downthread.
Instructions for building libpq in 64-bit mode are at
http://www.postgresql.org/docs/8.4/static/install-win32-libpq.html
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@pos
orks now, after I use win binary psql with flag -f, just as I
> said in my own answer.
Glad to see you got it working.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ch anyway?)
Wasn't that actually your idea? I would blame JD but I think he had
left by then?
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rkerMain
>> activities. This database is installed on a Windows OS. The version of
>> PostgreSQL is 8.4.1 (which I was hoping had a fix since I saw references to
>> a bug fix for a shared memory problem). Does anybody have any suggestions
>> on how to determine what causes these shu
=1307864
> https://bugs.launchpad.net/ubuntu/+bug/461105
This looks like an install from the 1-clicks, right? It looks to me
that it's not karmic-compatible - try installing the debian packages
instead (should be a simple apt-get install postgresql-8.4 - it's
included by default in
all other libraries you
> mentioned , dint get installed (or copied) to the PGHOME/lib directory if
> the same name library already present in the system (/lib and /usr/lib).
What happens if they are installed by the packaging system later on?
Won't that cause a conflict then?
--
Magn
ing a few general topics like
> "security", "replication", "high availability", "change management",
> "postgres upgrades", etc.
>
Not a bad idea. How about scheduling one or two "talk slots" for that,
and then maybe just have visitors tell
ot;CN=" ldapsuffix=",OU=Call Centre Users,OU=My
> Company,DC=notts,DC=net,DC=mycompany,DC=com"
>
> Can anyone spot where I've gone wrong?
ldapserver="notts.net.mycompany.com"
exclude the ldap:// part, and the base dn part.
--
Magnus Hagander
Me: http://w
a lot less writes here, but on 8.4 it's perfectly normal.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ere any plans to make this work?
Sure. 8.5 (current alpha release included) will let you do
i INT NOT NULL UNIQUE DEFERRABLE
which will make that work.
(you might want to consider using an actual email address if you want
to get responses to your questions in the future)
--
Magnus Hagande
E can solve your problem:
WITH t2 AS (SELECT 1 AS a)
SELECT * FROM t2 LEFT JOIN t3 ON TRUE
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
401 - 500 of 998 matches
Mail list logo
