On Thu, Aug 7, 2008 at 4:34 PM, Brian Maguire <[EMAIL PROTECTED]> wrote:
> We need to restore one table from a backup. What is the proper way to do
> this?
>
> Our backup command looks like this:
>
> pg_dump -C -Fc -S postgresql mydatabase > today.backup.sqlc
>
> I am using PostgreSQL 8.1.
You h
try whit this
http://www.postgresql.org/docs/8.3/interactive/ecpg-dynamic.html
--- On Thu, 8/7/08, Anderson dos Santos Donda <[EMAIL PROTECTED]> wrote:
> From: Anderson dos Santos Donda <[EMAIL PROTECTED]>
> Subject: [GENERAL] Create Table Dinamic
> To: pgsql-general@postgresql.org
> Date: Thur
On Aug 7, 2008, at 5:28 PM, Klint Gore wrote:
Alvaro Herrera wrote:
Merlin Moncure escribió:
> er, I see the problem (single piece of text with multiple encodings
> inside) :-). ok, it's more complicated than I thought. still, you
> need to convert the email to utf8. There simply must be a
Alvaro Herrera wrote:
Merlin Moncure escribió:
> er, I see the problem (single piece of text with multiple encodings
> inside) :-). ok, it's more complicated than I thought. still, you
> need to convert the email to utf8. There simply must be a way,
> otherwise your emails are not well define
"Ed L." <[EMAIL PROTECTED]> writes:
> We're seeing gobs of these via dmesg in PostgreSQL 8.3.3 on
> ia64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404
> (Red Hat 3.4.6-8), kernel 2.6.9-55.EL:
> postmaster(13144): floating-point assist fault at ip
> 403a9382, isr 04
On Thursday 08/07/08 @ 5:46 pm MDT, I received this from "Ed L."
> > postmaster(13144): floating-point assist fault at ip
> > 403a9382, isr 0408
>
> These are coming lately exclusively from the writer process...
Actually, the machine has been up for 45 days and dmesg doesn't
On Thursday 08/07/08 @ 5:43 pm MDT, I received this from "Ed L."
<[EMAIL PROTECTED]>:
> We're seeing gobs of these via dmesg in PostgreSQL 8.3.3 on
> ia64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6
> 20060404 (Red Hat 3.4.6-8), kernel 2.6.9-55.EL:
>
> postmaster(13144): floating-point assi
We're seeing gobs of these via dmesg in PostgreSQL 8.3.3 on
ia64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404
(Red Hat 3.4.6-8), kernel 2.6.9-55.EL:
postmaster(13144): floating-point assist fault at ip
403a9382, isr 0408
It appears to be an Itanium-specific
Jack Orenstein <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> So ... why didn't you just "yum install" the same ones on F-9?
> Can't find them.
You didn't look in the standard Fedora repositories?
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general
We need to restore one table from a backup. What is the proper way to do this?
Our backup command looks like this:
pg_dump -C -Fc -S postgresql mydatabase > today.backup.sqlc
I am using PostgreSQL 8.1.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to yo
On Thu, 2008-08-07 at 17:24 -0400, Jack Orenstein wrote:
> Pardon a dumb question. Installing Postgres 7.x on FC4-6, I would install a
> large set of RPMs, these I think:
>
> postgresql
> postgresql-contrib
> postgresql-devel
> postgresql-jdbc
> postgresql-libs
> pos
Tom Lane wrote:
Jack Orenstein <[EMAIL PROTECTED]> writes:
Pardon a dumb question. Installing Postgres 7.x on FC4-6, I would install a
large set of RPMs, these I think:
postgresql
postgresql-contrib
postgresql-devel
postgresql-jdbc
postgresql-libs
postgresql-pyth
On Wed, 2008-08-06 at 13:01 -0400, Kevin Murphy wrote:
> The package creates /usr/lib64/libpq.so.4.1, but it does not create
> /usr/lib64/libpq.so.4 -> /usr/lib64/libpq.so.4.1.
This is a bit strange:
[EMAIL PROTECTED] ~]# ll /usr/lib64/libpq.so.4.1
-rwxr-xr-x 1 root root 14 Jan 12 2008 /usr
Jack Orenstein <[EMAIL PROTECTED]> writes:
> Pardon a dumb question. Installing Postgres 7.x on FC4-6, I would install a
> large set of RPMs, these I think:
> postgresql
> postgresql-contrib
> postgresql-devel
> postgresql-jdbc
> postgresql-libs
> postgresql-python
>
Pardon a dumb question. Installing Postgres 7.x on FC4-6, I would install a
large set of RPMs, these I think:
postgresql
postgresql-contrib
postgresql-devel
postgresql-jdbc
postgresql-libs
postgresql-python
postgresql-server
I then had everything I need to run postgr
Glyn Astill <[EMAIL PROTECTED]> writes:
>> The conclusion of the thread seemed to be that it was a linker or
>> assembler problem triggered by our use of SUBSYS.o files to aggregate
>> all the backend .o files into a smaller number of files for the final
>> link. If so the answer is either (a) upd
> The conclusion of the thread seemed to be that it was a
> linker or
> assembler problem triggered by our use of SUBSYS.o files to
> aggregate
> all the backend .o files into a smaller number of files for
> the final
> link. If so the answer is either (a) update to a newer
> toolchain
> that migh
Since it supports master-slave with Slony, has anyone had good
experience using phpPgAdmin for master-slave? Not much in docs...
On Wed, Aug 6, 2008 at 2:59 PM, Bill Wordsworth
<[EMAIL PROTECTED]> wrote:
> Is there any GUI for master-slave (I prefer CLI too)?
>
> Are there any PostgreSQL-specific
Kevin Murphy <[EMAIL PROTECTED]> writes:
> Devrim GÃNDÃZ wrote:
>> Upstream (I mean, Tom) is building -jdbc package with open source
>> components for a long time, and I am following that, too. We were
>> directly installing the binary jar files under /usr/share/java without
>> compilation.
> Sp
Devrim GÜNDÜZ wrote:
On Thu, 2008-08-07 at 09:57 -0400, Kevin Murphy wrote:
When yum installs the PGDG postgresql-jdbc-8.3.3 RPM on CentOS 5, it
appears to want to drag in GCJ dependencies, but I want to use a Sun
JDK. The JDK is pre-installed by the Rocks V cluster distribution,
which is
Christian Strobl wrote:
> thanks for your answers. unfortunately i misworded my problem
> again. i have a very clear problem and i am looking for a
> solution of this problem (if it is basic or not) and i am not
> using RedHatEL/CentOS/Fedora. i am looking for a solution
> which is applicable t
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
I am using Postgres 8.1.4 on Linux. I am interested in the calculating the
following for a specific application:
How long it takes the operating system to fulfil a page demand, ie, reading the
page from disk or from the OS cache to the Postgres shared buffer.
Also how long it takes the bgwri
Merlin,
You are suggesting a fight with the flexible dynamics of email by
fitting it into a UTF shell - it doesn't always work.
I would suggest you read the postgresql definition of SQL-ASCII:
> The SQL_ASCII setting behaves considerably differently from the other
> settings. When the server cha
Merlin Moncure escribió:
> er, I see the problem (single piece of text with multiple encodings
> inside) :-). ok, it's more complicated than I thought. still, you
> need to convert the email to utf8. There simply must be a way,
> otherwise your emails are not well defined. This is a client sid
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_restore: connecting to database for re
On Thu, 2008-08-07 at 09:57 -0400, Kevin Murphy wrote:
> What's the easiest RPM-based way to install postgresql-jdbc on CentOS
> 5? I just became aware of the JPackage project, which seems
> appealing, but it doesn't have an up-to-date version of
> postgresql-jdbc.
I don't think that there is a
What's the easiest RPM-based way to install postgresql-jdbc on CentOS
5? I just became aware of the JPackage project, which seems appealing,
but it doesn't have an up-to-date version of postgresql-jdbc.
I'm using Devrim GÜNDÜZ's very nice PostgreSQL repository
(pgsqlrpms.org) with yum.
When
On Wed, Aug 6, 2008 at 11:59 PM, Craig Ringer
<[EMAIL PROTECTED]>wrote:
> Anderson dos Santos Donda wrote:
>
> > PS : If somebody want knows why I need to create this function, is
> because
> > in my db have 1000 tables with the some colums, and each time I have a
> new
> > client, I need to creat
On Thu, Aug 7, 2008 at 9:38 AM, Merlin Moncure <[EMAIL PROTECTED]> wrote:
> On Thu, Aug 7, 2008 at 1:16 AM, Sim Zacks <[EMAIL PROTECTED]> wrote:
>>
>>> I don't quite follow that...the whole point of utf8 encoded database
>>> is so that you can use text functions and operators without the bytea
>>>
Read about dynamic sql in Postgres documentation (EXECUTE statement):
http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html
Igor
-Original Message-
From: Anderson dos Santos Donda [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 06, 2008 9:10 PM
To: pgsql-general@postgresq
On Thu, Aug 7, 2008 at 1:16 AM, Sim Zacks <[EMAIL PROTECTED]> wrote:
>
>> I don't quite follow that...the whole point of utf8 encoded database
>> is so that you can use text functions and operators without the bytea
>> treatment. As long as your client encoding is set up properly (so
>> that data
hallo magnus,
thanks for your answer.
> Just run the "make" and "make install" commands in subdirs
> only. You will need to do it in src/interfaces/libpq and
> src/bin/psql to get a working psql.
that is the answer i was looking for.
> But you can certainly have control over the version on
hi tomasz,
thanks for your answers. unfortunately i misworded my problem again. i have a
very clear problem and i am looking for a solution of this problem (if it is
basic or not) and i am not using RedHatEL/CentOS/Fedora. i am looking for a
solution which is applicable to every linux os and no
On 2008-08-07 11:49, [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.
It is not a basic problem - it is your solution for a problem, which
maybe does have another, better solution.
> i have
[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
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 compiled.
i know that is possible to
Hi guys,
What's the way to count the read/write bytes of the checkpoint process
before 8.3 (no pg_stat_bgwriter view :-[ )
I want to distinguish bytes written by checkpoints and others written by
the background process
thanks
--
Cyril SCETBON
--
Sent via pgsql-general mailing list (pgsql-gen
38 matches
Mail list logo