The installer should have an option for 'client only' so you end up with
psql, pg_dump and friends but not the database.
From http://www.postgresql.org/download/windows :
pgInstaller packages are only being maintained for PostgreSQL 8.2 and 8.3.
8.3 pg_dump returns error for 8.4 database.
S
"Peter Headland" writes:
> The documentation of the COPY command does not state what character
> set(s) are recognized or written. I need to import and export UTF-8
> data; how can I do that?
set client_encoding = 'utf8';
copy from stdin/to stdout;
regards, tom lane
--
The documentation of the COPY command does not state what character
set(s) are recognized or written. I need to import and export UTF-8
data; how can I do that?
--
Peter Headland
Architect
Actuate Corporation
Hi -
I have a multi-threaded application that spawns child processes, inserts
information into the database, then disconnects. For whatever reason, some
of the children do not disconnect and the database is left with idle
connections (that eventually max out over time). How can I either force th
Andrus wrote:
Chris,
Thank you.
I don't know if you can do that. Why do you need to?
I need to run pg_dump at 2:00 AM every night automatically in Windows
computer where PostgreSql server is not installed.
The installer should have an option for 'client only' so you end up with
psql, pg_
I can not find command in postgres - With ... as
You need Postgres 8.4 for that:
http://www.postgresql.org/docs/current/static/queries-with.html
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpr
Help me please with this function writed in MSSQL. I want to pass on Postgres
CREATE OR REPLACE FUNCTION GetProductsByCategoryId
(IN CategoryId int, IN PageIndex int, IN NumRows int,
OUT CategoryName varchar(50), OUT CategoryProductCount int)
RETURNS SETOF RECORD LANGUAGE plpgsql as $$
DECLARE
Tom Lane a écrit :
Jean-Christophe Praud writes:
Indeed, the tables I tried to vacuum have locks on them.
AccessShareLock belonging to queries which seem sleeping. I tried to
kill these queries but pg_cancel_backend() has no effect, and the
process doesn't get the 15 signal.
How
Jean-Christophe Praud writes:
> Indeed, the tables I tried to vacuum have locks on them.
> AccessShareLock belonging to queries which seem sleeping. I tried to
> kill these queries but pg_cancel_backend() has no effect, and the
> process doesn't get the 15 signal.
> How can I get rid of these
On Wed, Sep 9, 2009 at 11:01 AM, Thomas Kellerer wrote:
> Hi,
>
> if someone from EnterpriseDB is "listening":
>
> The links for Windows and OSX binaries at
> http://www.enterprisedb.com/products/pgbindownload.do
>
> are interchanged.
> When clicking on the Windows icon, you'll get the Mac binari
Tom Lane a écrit :
Jean-Christophe Praud writes:
I've a problem on a heavy loaded database: vacuums don't work since
about a week. All I got is:
mybase=# vacuum verbose analyze public.mytable;
INFO: vacuuming "public.mytable"
(I stop it after hours)
Looking with top and
Alvaro Herrera a écrit :
Jean-Christophe Praud wrote:
Hi all,
I've a problem on a heavy loaded database: vacuums don't work since
about a week. All I got is:
mybase=# vacuum verbose analyze public.mytable;
INFO: vacuuming "public.mytable"
(I stop it after hours)
Looking with top and iotop
Jean-Christophe Praud writes:
> I've a problem on a heavy loaded database: vacuums don't work since
> about a week. All I got is:
> mybase=# vacuum verbose analyze public.mytable;
> INFO: vacuuming "public.mytable"
> (I stop it after hours)
> Looking with top and iotop, I see the process takes
Jean-Christophe Praud wrote:
> Hi all,
>
> I've a problem on a heavy loaded database: vacuums don't work since
> about a week. All I got is:
>
> mybase=# vacuum verbose analyze public.mytable;
> INFO: vacuuming "public.mytable"
> (I stop it after hours)
>
> Looking with top and iotop, I see the
Hi all,
I've a problem on a heavy loaded database: vacuums don't work since
about a week. All I got is:
mybase=# vacuum verbose analyze public.mytable;
INFO: vacuuming "public.mytable"
(I stop it after hours)
Looking with top and iotop, I see the process takes some cpu and disk io
time duri
that's part of action 'if you have a PC, buy a mac. But if you're
tired of Mac os x, install Windows' ;)
Probably part of soon coming windows7 happening. ;) ;) ;)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/
Hi,
if someone from EnterpriseDB is "listening":
The links for Windows and OSX binaries at
http://www.enterprisedb.com/products/pgbindownload.do
are interchanged.
When clicking on the Windows icon, you'll get the Mac binaries, when clicking
on the Mac icon, you'll get the windows binarie
Hi Sam,
Thanks for your help. Your solution seems to work. I may let you know
if I run into problems. Thanks again.
Best,
Jia
On Tue, Sep 8, 2009 at 11:31 AM, Sam Mason wrote:
> [ please CC the mailing list and not the list owner, they answer
> mailing list questions not PG questions ]
>
> On
On Tue, 08 Sep 2009 18:50:49 -0700, John R Pierce wrote about Re:
[GENERAL] where clauses and multiple tables:
>Yaroslav Tykhiy wrote:
>> By the way, folks, do you think there may be performance gain or
>> loss from rewriting this with an explicit JOIN? E.g.:
>>
>> SELECT DISTINCT foo.foo_id, foo
Greetings!
We've got a moderately busy DB host running PostgreSQL 8.3.7 from Debian Lenny
with WAL archiving. It's been rsyncing its WAL files to a backup host for the
last year or so, with the following archive_command:
ssh pgbac...@backup test ! -f pgbackup-cirkus/%f && rsync -az %p
pgbac...@b
That query looks suspiciously similar to a SQL Server (Sybase or
Microsoft) query.
@@options is the name of a SQL Server global variable. It looks like
your client application thinks that it is connected to a copy of SQL
Server, not Postgres.
-- Korry
On Sep 9, 2009, at 4:27 AM, C
On 09/09/2009 09:27, Chris Leahy wrote:
> Hi All
>
> I'm running postgreSQL 7.3 on 2 installations, both with the same problem.
>
> The error logs for both installations are filling up with the following;
>
> ESTERROR: 42703: column "options" does not exist
> ESTLOCATION: transformColumnRef, par
Chris,
Thank you.
I don't know if you can do that. Why do you need to?
I need to run pg_dump at 2:00 AM every night automatically in Windows
computer where PostgreSql server is not installed.
If you reference the original files (c:\program files\... or where-ever
you installed postgres to
Hi All
I'm running postgreSQL 7.3 on 2 installations, both with the same
problem.
The error logs for both installations are filling up with the following;
ESTERROR: 42703: column "options" does not exist
ESTLOCATION: transformColumnRef, parse_expr.c: 396
ESTSTATEMENT: select @@options
This has
I use postgres 8.3 on Windows
I try to realize warm standby sheme, described in Chapter 24. Backup and
Restore in postgres docs
(http://www.postgresql.org/docs/8.3/interactive/warm-standby.html#WARM-STANDBY-RECORD).
When i try to stop postgres server, it can't be stop because
'restore_command'
25 matches
Mail list logo
