> ..
> ..
> COPY prdxgdat FROM 'Z:/data-2016-04-50.csv' WITH DELIMITER ',' CSV HEADER Y
>
> 50 files -> 50 COPY command, In my use case I think this is not a good way
> to load data, Can you suggest any better way to do this?
>
> I can always write e
On Feb 17, 2017 06:53, "John R Pierce" wrote:
On 2/16/2017 9:43 PM, Magnus Hagander wrote:
>
Perhaps something like "COPY FROM PROGRAM 'cat /path/*.csv'" would work for
you?
he's using HEADER, so cat wouldn't work.he's also using MSDOS/WIn
On Thu, Mar 23, 2017 at 7:57 AM, Charles Clavadetscher <
clavadetsc...@swisspug.org> wrote:
> Hello
>
> I would like to upload the slides of my presentation at Nordic PGDay
> 2017. Could you please grant me edit privilege on the wiki?
>
> My user name is cclavadetscher
&g
ite unlikely that it would hit somebody, but the risk is
there. And people generally auto-upgrade to the latest minor releases,
whereas they at least in theory read the top of the release notes when
doing a major upgrade (ok, most people probably don't, but at least some
do).
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
n, but in the previous attempts it
certainly hasn't been "many users". It could be that whomever set them up
did a bad job of course, I can't judge that as I didn't personally use them
more than take a look every now and then.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Wed, Apr 5, 2017 at 6:31 PM, Adrian Klaver
wrote:
> On 04/05/2017 09:17 AM, Magnus Hagander wrote:
>
>
>> This has been tried a number of times. I'ts been a couple of years since
>> I last saw one, but multiple people have set up forums, either mirrored
>> or
ers who *are* willing to do that, and
they make that platform work. So I'm very grateful for those people doing
it, even better that it's not me.
And also, if somebody wants to take another stab at trying to make web
forums for PostgreSQL, I say let them try. I don't think it would work, but
I'd be happy to be proven wrong.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
ht be able to make upstream
> changes to remove the need for others.
>
That'd be useful. I think you should also include Devrim to figure out what
things would actually make *both* sides happier.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
the selinux docs for how to figure out what
is wrong and probably use restorecon to get things back in order.
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
Postgres 10, so it's considered to be deprecated for quite some time.
> Is there a way to build a Debug version of the libraries?
> I'm building my app in Debug mode right now and prefer not to mix the
> libraries.
> Especially since I know Debug and Release version with MSVC li
On Wed, May 3, 2017 at 11:31 PM, John R Pierce wrote:
> On 5/3/2017 2:20 PM, Magnus Hagander wrote:
>
>>
>> Please note that this method of building libpq has been removed from
>> Postgres 10, so it's considered to be deprecated for quite some time.
>>
>&g
On Thu, May 4, 2017 at 12:06 AM, Igor Korot wrote:
>
> On Wed, May 3, 2017 at 5:20 PM, Magnus Hagander
> wrote:
> > On Tue, May 2, 2017 at 4:49 AM, Igor Korot wrote:
> >>
> >> John,
> >>
> >> On Mon, May 1, 2017 at 9:38 PM, John R Pierce
&g
On Thu, May 4, 2017 at 7:32 PM, John R Pierce wrote:
> On 5/4/2017 2:19 AM, Magnus Hagander wrote:
>
> On Wed, May 3, 2017 at 11:31 PM, John R Pierce
> wrote:
>
>> On 5/3/2017 2:20 PM, Magnus Hagander wrote:
>>
>>>
>>> Please note that this m
with wsock32.lib...
>
I suggest you try building it with the supported method (the msvc build
system in src/tools/msvc), and then inspect the difference.
You can also look up those references in the Microsoft docs (for each API
function there is a listing at the bottom of the page tell
e latin9 encoding, and then do a second
migratino which changes the encoding from 9.6 w latin9 to 9.6 w utf8. That
way you can get access to the newer tools such as pglogical to help you do
that.
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
present.
But it should perhaps be more clearly documented somewhere.
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
> This seems to be new with 10. I recently began testing the
> pacemaker resource agent against PG 10. I never had (or noticed) this
> failure with 9.6.1 and 9.6.2.
>
Hah, that's an interesting failure. In the name of the slot, the 2194 comes
from the pid -- but it's the pid o
(I think) SSL_get_peer_certificate() to get at it.
(this is what libpq does and stores it in ->peer, but that's a private api.
But you can see be-secure-openssl.c for some examples)
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
really mention that in the docs. What do others
> think?
>
If the documentation is missing such a clearly critical step, then I would
say that's a definite documentation bug and it needs to be fixed. We can't
really fault people for missing a small detail if we didn't
is it something where I need to
> pick one way to do it?
>
This looks like you are trying to connect with the actual username
user1¡A.DOMAIN.TLD. pg_ident only sets what you are allowed to log in as,
not what it will attempt.
If you are using psql, you are probably doing something like "psql -h
myserver". You need to add the user, so "psql -h myserver -U user1", to
instruct it of which username to actually use for the login.
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
On Wed, Sep 20, 2017 at 8:53 AM, Nicklas Avén
wrote:
> Hallo all
>
> I am thrilled about logical replication in PostgreSQL 10. My head have
> started spinning about use cases.
>
> Would it be possible to use logical replication as a distribution
> method of data?
>
As an answer to the generic q
On Wed, Sep 20, 2017 at 10:02 AM, Nicklas Avén
wrote:
> On Wed, 2017-09-20 at 09:44 +0200, Magnus Hagander wrote:
>
> On Wed, Sep 20, 2017 at 8:53 AM, Nicklas Avén
> wrote:
>
> Hallo all
>
> I am thrilled about logical replication in PostgreSQL 10. My head have
>
n?
Certainly. Unrelated to PostgreSQL, this is a standard feature in Debian.
Commonly used to prevent things like kernel upgrades from happening on the
same schedule as others.
Basically, you put the package "on hold". See the debian administratino
guide at
https://debian-administrati
use a restart. I run upgrades
> without any applications running so I don't know exactly what could
> happen when using unattended upgrades.
>
libpq does get upgraded, but it does not cause restarts. A restart of a
client application using libpq must be done manually by the administrator
(unless there is specific code in the client application or it's packaging
to deal with that).
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
On Thu, Jan 31, 2008 at 03:34:05PM +0100, Martijn van Oosterhout wrote:
> On Thu, Jan 31, 2008 at 01:28:48PM +, Simon Riggs wrote:
> > That sentence has no place in any discussion about "backup" because the
> > risk is not just a few transactions, it is a corrupt and inconsistent
> > database f
On Thu, Feb 07, 2008 at 11:26:27AM +0100, Jean-Samuel Reynaud wrote:
> Hi All,
>
> I want to migration an existing database from a 32bit server to a 64bit
> server. I will use exactly the same postgresql version (8.2.6).
> Did I need to dump the data to do this or a single copy of /data will
> wor
Rainer Bauer wrote:
Monday, January 28, 2008, 12:45:16 PM, you wrote:
MH> On Mon, Jan 28, 2008 at 10:07:43AM +0100, Rainer Bauer wrote:
Hello,
I cannot retrieve any list messages through the news server anymore
(since last Tuesday). Are there any known problems?
The reported error is: "503 NNT
Ken Johanson wrote:
Stephen Frost wrote:
* Ken Johanson ([EMAIL PROTECTED]) wrote:
But given the recent and dramatic example of 8.3's on-by-default
stricter typing in functions (now not-autocasting), I worry that kind
of change could happen in every minor version (8.4 etc).
8.3 isn't a minor
Ken Johanson wrote:
Magnus Hagander wrote:
PG uses a different versioning system than this one?:
http://en.wikipedia.org/wiki/Software_versioning#Numeric
Or do you mean the changes are not minor? :-)
Yes, we use the one stated on our site, not wikipedia ;)
See: http://www.postgresql.org
On Mon, Feb 11, 2008 at 03:26:39PM +0100, Ivan Sergio Borgonovo wrote:
> On Mon, 11 Feb 2008 08:46:00 -0500
> "Christopher Browne" <[EMAIL PROTECTED]> wrote:
>
> > On Feb 11, 2008 8:04 AM, Ivan Sergio Borgonovo
> > <[EMAIL PROTECTED]> wrote:
> > > I did manage to find an announcement about the sup
On Mon, Feb 11, 2008 at 08:46:00AM -0500, Christopher Browne wrote:
> On Feb 11, 2008 8:04 AM, Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote:
> > I did manage to find an announcement about the support of pg for
> > windows... but I wasn't able to see anything you'd have a summary of
> > scheduled
Dawid Kuroczko wrote:
On Feb 13, 2008 10:49 AM, Csaba Nagy <[EMAIL PROTECTED]> wrote:
http://www.theserverside.com/news/thread.tss?thread_id=48339
The interesting part is where somebody asks why NOT use postgres, and
it's answers could give some additional hints to those interested on
what peop
Maarten Boekhold wrote:
Hi,
Richard Huxton wrote:
INDIANNIC-HOSTING wrote:
a) if your server is hosted in a dataceneter
for installation on windows 2000 you cannot use terminal service.
Hmm - this *should* be documented somewhere. I don't really use
Windows and I know about it somehow.
Dan Armbrust wrote:
Are there any known regression issues WRT performance on the 8.3.0.1
binary build for windows?
And I mean serious -multiple orders of magnitude- performance issues
running simple queries on a small database...
A little more background. I built 8.3.0 on Cent OS 5 today. Sta
Dave Page wrote:
On Fri, Feb 15, 2008 at 4:21 PM, Tony Caduto
<[EMAIL PROTECTED]> wrote:
paul rivers wrote:
>>
> Going from 8.2.4 and 8.2.6 to 8.3.0 has been painless for me.
> However, unlike the blogger you cite, I read the directions before,
> not after, attempting it.
The blogger has
On Mon, Feb 18, 2008 at 04:11:14PM +0100, Hermann Muster wrote:
> Dave Page schrieb:
> >On Feb 18, 2008 10:05 AM, Hermann Muster <[EMAIL PROTECTED]> wrote:
> >
> >>Hi Dave,
> >>
> >>after testing several combinations I can tell you following, because
> >>maybe I couldn't make clear what my proble
On Mon, Feb 18, 2008 at 06:35:11PM -0300, Alvaro Herrera wrote:
> Bruce Momjian escribió:
> > Magnus Hagander wrote:
>
> > > For the case of upgrading, it wouldn't work. But there are certainly
> > > other cases where it would help. Say from your central pgad
On Mon, Feb 18, 2008 at 05:01:22PM +, Dave Page wrote:
> On Feb 18, 2008 4:52 PM, Bill Moran <[EMAIL PROTECTED]> wrote:
> > In response to "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>:
> >
> >
> > > Hi
> > >
> > > My porting experiment has encountered the SQL Server UniqueIdentifier
> > > problem.
On Tue, 2008-02-19 at 11:07 -0500, Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
> >> Lack of support for Windows, which it sounds like the OP might be running?
>
> > That's something that's been on my agenda for a while. There are ce
On Tue, Feb 19, 2008 at 07:58:20PM -0500, Tom Lane wrote:
> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> > when i try to uninstall tsearch2 i get this error,
>
> Hmm, maybe you originally put tsearch2 into some other schema than
> "public"? If so, try setting search_path to point to that sch
On Mon, Feb 25, 2008 at 06:40:43PM +0100, Andreas Lau wrote:
> Hello,
>
> I try to restore a dump file on a new Database. But unfortunatly i get this
> error:
>
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 532; 2612 16386 PROCEDUR
On Tue, Feb 26, 2008 at 10:26:25AM +0100, Martijn van Oosterhout wrote:
> On Tue, Feb 26, 2008 at 10:23:05AM +0100, Magnus Hagander wrote:
> > Any chance you are running pg_dump/pg_restore version 8.3? The syntax
> > appears to be what 8.3 uses, not 8.3..
> >
> > You
[EMAIL PROTECTED] wrote:
Hi,
I urgently need a way to simply backup the database's data on win32
(e.g. the 'data' directory).
As discussed earlier I can't use dump/dumpall since my data needs
persistent tableoids which, however, are not the same after a restore.
AFAIK stopping the server, zipp
On Wed, Feb 27, 2008 at 11:11:52AM +1300, Tim Uckun wrote:
> I just downloaded postgres 8.3 for windows and noticed that citext is
> not an option for columns.
>
> The web site has the source code but no binaries for windows.
That is something you need to talk to the citext creators about. Ideall
On Tue, Feb 26, 2008 at 11:51:34PM -, Joris Dobbelsteen wrote:
> >> AFAIK stopping the server, zipping data dir, and restarting
> >the server
> >> creates a zip file which is not easily portable to other
> >computers due
> >> to some ntfs file system permission problems.
> >>
> >IIRC you h
On Tue, Feb 26, 2008 at 10:30:02PM +0100, Gevik Babakhani wrote:
> > AFAIK stopping the server, zipping data dir, and restarting
> > the server creates a zip file which is not easily portable to
> > other computers due to some ntfs file system permission problems.
> >
> IIRC you have to re-assig
On Wed, Feb 27, 2008 at 02:41:09PM +, Richard Huxton wrote:
> Jan Christensen wrote:
> >Dear Sirs.
> >
> > I have a problem with installing PostgreSQL 8.3 on my computer
> > with Windows XP Home edition and AVG FREE antivirus 7.5.
> >
> > The installation-program asks for a installing-
On Wed, Feb 27, 2008 at 03:59:24PM +0100, [EMAIL PROTECTED] wrote:
> On 22:37 Tue 26 Feb , Magnus Hagander wrote:
> > [EMAIL PROTECTED] wrote:
>
> >> AFAIK stopping the server, zipping data dir, and restarting the server
> >> creates a zip file which is not easi
On Wed, Feb 27, 2008 at 02:58:22PM +, Richard Huxton wrote:
> Magnus Hagander wrote:
> >On Wed, Feb 27, 2008 at 02:41:09PM +, Richard Huxton wrote:
> >>I'm guessing that you're missing some of the locale (language) files for
> >> your machine. Have
On Mon, Mar 03, 2008 at 11:33:17AM +0100, A. Kretschmer wrote:
> am Mon, dem 03.03.2008, um 11:01:17 +0100 mailte dfx folgendes:
> > Dear Sirs,
> >
> > it is possible to connect to PostgreSQL server from a client with a dynamic
> > IP (or from an unknown IP)?
>
> Of course, yes.
>
>
> >
> > H
On Mon, Mar 10, 2008 at 01:43:03PM +0700, Christian Teguh wrote:
> Hi guys, i just wondering, i there a way to make PostgreSQL database like M$
> Access. That have only single or several files without installing it.??
> Thanks for your attention.
No.
Unless you create a file and mount a loopback f
On Mon, Mar 10, 2008 at 06:55:48AM +, Raymond O'Donnell wrote:
> On 09/03/2008 22:33, Reid Thompson wrote:
> >On Sun, 2008-03-09 at 19:41 +, Raymond O'Donnell wrote:
> >>On 09/03/2008 15:34, Reid Thompson wrote:
> >>
> >>>you'll also probably have to add the parameter -h 127.0.0.1
> >>psql
On Wed, 2008-03-12 at 14:22 -0400, Lee Hachadoorian wrote:
> It was far stupider than that. I had been playing around with a
> couple of different data clusters before doing a complete reinstall of
> PostgreSQL. I just realized I was trying to start a cluster that I
> was no longer using and the
On Thu, Mar 13, 2008 at 08:08:27PM -0400, Tom Lane wrote:
> "Andrej Ricnik-Bay" <[EMAIL PROTECTED]> writes:
> > On 14/03/2008, rrahul <[EMAIL PROTECTED]> wrote:
> >> I see Mysql bosting for Google,Yahoo, Alcatel..
> >> What about Postgres the list is not that impressive.
>
> > What then? Coul
On Fri, Mar 14, 2008 at 02:29:07AM +0100, Ivan Sergio Borgonovo wrote:
> On Thu, 13 Mar 2008 20:08:27 -0400
> Tom Lane <[EMAIL PROTECTED]> wrote:
>
> > "Andrej Ricnik-Bay" <[EMAIL PROTECTED]> writes:
> > > On 14/03/2008, rrahul <[EMAIL PROTECTED]> wrote:
> > >> I see Mysql bosting for Google,Yahoo
Arturo Pérez wrote:
Who should I contact to bring this to their attention?
Marc Fouriner, [EMAIL PROTECTED]
//Magnus
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Stefan Sturm wrote:
Hello,
is there a Way to install PostgreSQL ( 8.3.1 ) on a Win2000 Maschine
without Admin Rights?
Yes, but you cannot use the MSI installer, and you cannot install it as
a service (for auto-start). You can download the binaries-no-installer
and run the initdb and pg_ctl
If you can do that, you obviously have admin rights, so why not just use
the MSI installer?
That said, this often happens if you have an incorrect version of the
MSVC runtime on your system. See the README file in the download directory.
//Magnus
Stefan Sturm wrote:
Hello,
i copied the dll
Stefan Sturm wrote:
Hello,
If you can do that, you obviously have admin rights, so why not just
use the MSI installer?
When I try to run the Intaller, I get this Message: "The
Systemadminitrator guidelines issued in order to prevent this
installation".
Oh. So it's not actually admin righ
On Wed, 2008-03-26 at 08:28 +0100, Stefan Sturm wrote:
> Hello,
>
> I tried everything to get init_db working, but I failed :-(
> So I tried another way. I tried Veriosn 8.2. With 8.2 I got another
> DLL missing. So I tried 8.1.
> And look, it works :-) No DLL problems.
>
> But now init_db tells
Olexandr Melnyk wrote:
> Hello,
>
> I'm interested in applying for this year's GSoC program, to work on
> PL/Mono: pluggable procedural language for PostgreSQL. The main
> purpose of the project is to allow programmers to write stored
> procedures for PostgreSQL database in one of the languages th
Tony Caduto wrote:
Tom Lane wrote:
This must be coming from calculate_database_size(). Is
$PGDATA/pg_tblspc actually missing? If the guy has no custom
tablespaces, I can believe that nothing except pg_database_size()
or pg_tablespace_size() would try to touch that subdirectory, so
he might not
Joshua D. Drake wrote:
On Mon, 07 Apr 2008 10:26:23 -0500
Tony Caduto <[EMAIL PROTECTED]> wrote:
You can use the Lightning Admin win32 debugger, very stable and FREE.
The edb-debugger is open source??? Or are you just saying that although
the Lightning Admin debugger is not open source it is
Joshua D. Drake wrote:
> On Mon, 07 Apr 2008 19:07:22 +0200
> Magnus Hagander <[EMAIL PROTECTED]> wrote:
>
>
> > Yes. The edb debugger is open source (it's on pgfoundry), and the
> > LA debugger client is free-as-in-beer. You know, kinda like
> > Postgre
Simone Brunozzi wrote:
> Greetings, guys,
> do you know of any interesting Postgresql Conferences/events in Europe
> in 2008? Or PHP/Python events as well?
There will be a pgDay in Italy in october (www.pgday.it), and IIRC
there is also a pgDay or so coming up in France, but I don't think
they've
Tomasz Ostrowski wrote:
> On 2008-04-11 08:53, J Ottery wrote:
>
> > I install PostgreSQL on a client PC and put the data files on a
> > networked drive (instead of the local drive). Postgres as user and
> > localport. This works well.
>
> This is not the way it is meant to work, and it can eat
Craig Ringer wrote:
> Orlando Solarte wrote:
> > Hi.
> >
> > I am trouble with my server postres on linux. It crashed!. I have
> > folder postgres installation that was my server. Is possible
> > recovery data from folder postgres installation? For example folder
> > data?
>
> Unfortunately you
Bruce Momjian wrote:
> Ron Mayer wrote:
> > Magnus Hagander wrote:
> > > Craig Ringer wrote:
> > >> with a version of PostgreSQL with the same minor version as the
> > >> one you were using on the server, eg if you were using 8.1.4 you
> > >> s
Tom Lane wrote:
"vyang" <[EMAIL PROTECTED]> writes:
I'm having trouble with postgres filling the log with SSL SYSCALL error: A
blocking operation was interrupted by a call to WSACancelBlockingCall.
That was fixed some time ago:
2007-05-17 21:20 tgl
* src/backend/libpq/: be-secure.c
Dan "Heron" Myers wrote:
> Craig Ringer wrote:
> > Can you send me a complete, compileable example that illustrates
> > the problem, along with instructions on how to reproduce it? If
> > possible, send a compiled binary and any dependencies too. I'm
> > curious to see if this is in fact shared
Nathan Thatcher wrote:
> So what options does that leave all of us who need to compile and run
> our custom C functions in Windows?
Debug further :-)
Because it's certainly possible to do it. IIRC, PostGIS for 8.3 is
build with MingW and it works fine. And other extensions are known
working when
William Temperley wrote:
> Dear All
>
> Sometimes postgres.exe will thrash one of the cores and won't stop
> until I kill the process. I know it's the statistics collector as I
> get this message when I kill the process:
> "statistics collector process (PID 172) exited with exit code 1"
> Nothing
William Temperley wrote:
> > >
> > > Any ideas why this might be happening, and how I can stop it?
> >
> > It'd be interesting to know what the stats collector is actually
> > doing. Could you, using Process Explorer or a debugger, get a stack
> > trace from that process while it's in the trashi
William Temperley wrote:
> On Thu, May 8, 2008 at 6:14 PM, Magnus Hagander <[EMAIL PROTECTED]>
> wrote:
> > William Temperley wrote:
> >> > >
> >> > > Any ideas why this might be happening, and how I can stop it?
> >> >
> >>
William Temperley wrote:
> On Fri, May 9, 2008 at 2:55 PM, Magnus Hagander <[EMAIL PROTECTED]>
> wrote:
>
> > William Temperley wrote:
> > > On Thu, May 8, 2008 at 6:14 PM, Magnus Hagander
> > > <[EMAIL PROTECTED]> wrote:
> > > > William T
Howard Cole wrote:
> Adrian Klaver wrote:
> > On Friday 23 May 2008 6:02 am, Howard Cole wrote:
> >
> >> Howard Cole wrote:
> >>
> Looks like someone or something changed the permissions on the
> postgresql folders or files.
>
> Sincerely,
>
> Joshua D. Drake
>
Per Lauvås wrote:
> Hi
>
> I am running Postgres 8.2 on Windows 2003 server SP2.
>
> Every now and then (2-3 times a year) our Postgres service is down
> and we need to manually start it. This is what we find:
>
> In log when going down:
> 2008-06-02 13:40:02 PANIC: could not open file
> "pg_xl
egments
> fill up (not using timeout) and we are able to recover within a 10
> minute interval.
>
> Could it be that this copy operation is causing the problem?
>
> Per
>
> -Original Message-
> From: Magnus Hagander [mailto:[EMAIL PROTECTED]
> Sen
Per Lauvås wrote:
> Hi, and thanks for the replies!
>
> OK. I think we will reconsider this. The backup procedure was set up
> a few years ago. I have personally made several point in time
> recoveries using this technique (for testing purposes), and it works.
> But I guess an undesirable side-eff
I think that if you use a RULE instead of a TRIGGER to redirect the
write, it should return the proper number of rows inserted in the child
table.
//Magnus
[EMAIL PROTECTED] wrote:
> Scott,
> You're right, of course. I meant, is there a way to make Postgres return
> the number of rows inserted t
s descibed in the docs:
> http://www.postgresql.org/docs/8.3/interactive/ddl-partitioning.html
>
> Unfortunately, I still get
> "Query returned successfully: 0 rows affected, 16 ms execution time."
>
> /Mattias
>
>
>
>> -Original Message-
>> Fr
Dave Page wrote:
> On Tue, Jun 10, 2008 at 5:56 PM, Tatsuo Ishii <[EMAIL PROTECTED]> wrote:
>> Is it possible for non-software services to be listed in the list?
>> What I have in my mind is, PostgreSQL Certification program.
>
> Hi,
>
> The software catalogue is just for software - a certificati
know/care if a table is
> partitioned or not.
>
> /Mattias
>
>> -Original Message-
>> From: Magnus Hagander [mailto:[EMAIL PROTECTED]
>> Sent: den 11 juni 2008 10:43
>> To: Arbin Mattias
>> Cc: pgsql-general@postgresql.org
>> Subject: Re: [GEN
Łukasz Czerpak wrote:
> Hi,
>
> We have problems with PostgreSQL on Windows.
>
> PostgreSQL: 8.3.1
> System: Windows XP (SP3)
> FS: NTFS
> Hardware: IBM x3650, 1x Xeon Quad, 2GB RAM
>
>
> The database is accessed from multiple windows apps. One of them has a
> connection pool, the others use si
Łukasz Czerpak wrote:
> Magnus Hagander wrote:
>>
>> 487 is "Invalid address".
>>
>> Do you have any antivirus or similar software on the machine? If so, try
>> uninstalling it and trying again (just disabling it is usually not
>> enough).
>>
Taha Ozket wrote:
> Hi,
>
> I have a ldap group, "pgsql-developers". I have an user (user1) member
> of this group;
>
> group
> dn: cn=pgsql-developers,ou=Groups,o=Dep,dc=x,dc=x,dc=x
> objectClass: groupOfUniqueNames
> objectClass: top
> cn: SVN Committers
> uniqueMember: uid=user1,ou=Users,o=Dep
Actually, is there any particular reason why we can't *add* that column
to the view in a future version? We certainly shouldn't go modify it,
but adding to it should be pretty safe, no?
--
Magnus Hagander
Self: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
Fra
Plus product. The community product
packaged by enterprisedb is something different. I thought we had
pgagent as a stackbuilder application, but it seems I was mistaken.
Dave?
--
Magnus Hagander
Self: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general m
ensource product.
> Is it possible set define the default search_path for a given user?
In the community version you can. I don't know if this works in
EnterpriseDB. You'd just use
ALTER USER userid SET search_path='schema1,schema2'
--
Magnus Hagander
Self: http://www.
04:31:02 LOG: startup process (PID 1484) exited with exit code 1
> 2009-07-28 04:31:02 LOG: aborting startup due to startup process failure
> 2009-07-28 04:31:02 LOG: logger shutting down
>
> Thanks in advance for any insights.
>
> Jus
>
--
Magnus Hagander
Self: http:/
the bullet now, and switch to integer
timestamps. That way, the 8.4->8.5 migration will be easier.
If it's ever going to be changed, I doubt it's going to get any
*easier* than doing it right now.
--
Magnus Hagander
Self: http://www.hagander.net/
Work: http://www.redpill-linpro.co
/wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows
>
> Accessible from "General Articles and Guides" -> "Troubleshooting" ->
> "Generating_a_stack_trace_of_a_PostgreSQL_backend".
This is very useful, thanks for putting it up!
--
Magnus Hagander
27;s documented in "26.2.
The Statistics Collector", specifically 26.2.2.
--
Magnus Hagander
Self: 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
pdated to support
PostgreSQL 8.4. The hints it gives are for 8.3 and earlier. It would
probably be a good idea if they gave a warning for that, but I take it
they don't :-)
There may be other issues as well, so read up on the documentation for
anything else it recommends to change.
A
On Fri, Jul 31, 2009 at 15:47, Ashesh
Vashi wrote:
> Magnus Hagander wrote:
> AFAICS, the edb tuning wizard has not (yet) been updated to support
> PostgreSQL 8.4. The hints it gives are for 8.3 and earlier. It would
> probably be a good idea if they gave a warning for that, but I ta
also available on the web at
http://2009.pgday.eu/callforpapers
We look forward to hearing from you, and seeing you in Paris!
--
Magnus Hagander
Self: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To ma
ing modified at all in the source or share files, like
postgresql.conf.sample?
2) Any antivirus software on the machine?
3) Any chance you're simply out of memory? :-)
--
Magnus Hagander
Self: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mail
ot;store
the password in a file on the client" then? You can use a .pgpass file
for that, and just add something to your application that will prompt
for the password and add it to the file when the app starts. pgAdmin
does it this way.
--
Magnus Hagander
Me: http://www.hagander.net/
Work
us-test-a-patch-for-the-Win32-shared-memory-issue.html
for binaries with an experimental patch.
--
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 sub
On Sun, Aug 9, 2009 at 10:22, Abraham, Danny wrote:
> Does anybody have a proven way to regenerate this problem?
>
> SO that I can tell that the patch really does fix it?
No. That's the reason it has taken so long to figure out how to fix it
(which we hopefully have done now).
201 - 300 of 998 matches
Mail list logo
