On Thu, 7 Aug 2008, Cyril SCETBON wrote:
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
The reason that view was added was because
use the double quotes (")
ALTER USER "foo-bar" WITH ENCRYPTED PASSWORD 'foo-bar'
--- On Fri, 8/8/08, Tom Copeland <[EMAIL PROTECTED]> wrote:
> From: Tom Copeland <[EMAIL PROTECTED]>
> Subject: [GENERAL] ALTER ROLE role-name-with-hyphen
> To: pgsql-general@postgresql.org
> Date: Friday, August 8
On Aug 8, 2008, at 4:57 PM, Tom Lane wrote:
Tom Copeland <[EMAIL PROTECTED]> writes:
This is probably a new bee question... but, how do I change the
password of a role that has a hyphen in the name?
You need double quotes, not single quotes. Read about SQL identifier
syntax in the fine manu
Tom Copeland <[EMAIL PROTECTED]> writes:
> This is probably a new bee question... but, how do I change the
> password of a role that has a hyphen in the name?
You need double quotes, not single quotes. Read about SQL identifier
syntax in the fine manual ...
regards, tom
Hi all -
This is probably a new bee question... but, how do I change the
password of a role that has a hyphen in the name?
==
$ createuser --no-superuser --createdb --no-createrole foo-bar
$ psql
Welcome to psql 8.3.0, the PostgreSQL interactive terminal.
Type: \copyrigh
Jack Orenstein <[EMAIL PROTECTED]> writes:
> Our application is running Postgres 7.4, (working on conversion to 8.3
> right now). Our testing involves various forms of violence, including
> shutting off power and kill -9 postmaster.
Do you have reason to trust either your kernel or your disk drive
Tom Lane wrote:
Kevin Murphy <[EMAIL PROTECTED]> writes:
Speaking as a near-ignoramus, would a simple RPM that wraps the binary
jar file make sense?
Sure, if you want to do it that way. We did in fact do it that way up
till about 8.0. We (or at least I) moved away from it because of
Our application is running Postgres 7.4, (working on conversion to 8.3
right now). Our testing involves various forms of violence, including
shutting off power and kill -9 postmaster.
Occasionally we observe a form of database corruption in which one of
the files storing a table or index disappea
Never mind. I found it.
On Fri, 2008-08-08 at 12:16 -0400, Heeman Lee wrote:
> Hi,
>
> I can't find pgbench on the package we installed. I built, contrib pkg
> and installed, but that still didn't generate pgbench anywhere.
> Any idea where to get pgbench?
>
> --
> Heeman Lee
--
Heeman Lee
Hi.
Is this helpful?
http://winpg.jp/~saito/psqlODBC/psqlODBC64/
as for AMD64.
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
Regards,
Hiroshi Saito
- Original Message -
From: Lucas Felix
To: pgsql-general@postgresql.org
Sent: Saturday, August 09, 2008 12:00 AM
Subject: [GE
Steve Atkins wrote:
So, yeah, you're right. Generally, email is too complex to deal with
in the database as anything other than an opaque bytea blob, along
with some metadata
Only because that's the choice made by dbmail. As an IMAP server, it
doesn't _have_ to do more. The downs
Hi,
PHP has several functions related to postgresql - including a function to
fetch all the rows of the resultset at once into an array and then have a
loop that extracts one row at a time from that :
http://in.php.net/manual/en/function.pg-fetch-all.php
search for all functions with pg_ prefix
On Thu, 2008-08-07 at 17:24 -0400, Jack Orenstein wrote:
> Using pgdg-83-fedora.repo, yum finds two RPMs,
> postgresql-8.3.3-1PGDG.f9.i386 and
> postgresql-libs-8.3.3-1PGDG.f9.i386.
Uh... Use yum search postgresql :)
sudo yum search postgresql|wc -l
145
:)
--
Devrim GÜNDÜZ
devrim~gunduz.org,
Hi,
I can't find pgbench on the package we installed. I built, contrib pkg
and installed, but that still didn't generate pgbench anywhere.
Any idea where to get pgbench?
--
Heeman Lee
On Thu, 2008-08-07 at 17:56 -0400, Jack Orenstein wrote:
>
> Can't find them. They aren't on postgresql.org (e.g.
> http://www.postgresql.org/ftp/binary/v8.3.3/linux/rpms/fedora/fedora-9-i386/),
>
> and apparently not on pgdg-83-fedora.repo.
pgdg-83-fedora.repo uses http://yum.pgsqlrpms.org as
Olá, estou com um problema, o Windows Vista não reconhece o odbc do
PostgreSQL, alguma dica?
Hello, I have a problem, Windows Vista does not recognize the odbc of
PostgreSQL, any hint?
--
Lucas Felix de Sousa
Técnico em Informática
[EMAIL PROTECTED]
"Se enxerguei mais longe que outros homens, f
In response to "窦德厚(ddh)" <[EMAIL PROTECTED]>:
> Hi, if I have such a table:
>
> t_ref_id t_data
>
> 1 'abc'
> 2 '321'
> 1 'ddd'
> 2 'xyz'
> 9 '777'
> ...
>
>
> I want to get data with a special t_ref_id:
>
>
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
On Thu, Aug 07, 2008 at 10:55:06AM -0300, Anderson dos Santos Donda wrote:
> Each client has a db, and each db has the same tables. I don't need to share
> datas with the clients ( and I can't do it ) , because each clients have
> differents datas in yours tables.
>
> My function is to help me to
Its 8.1 and I'm doing a Vacuum using the vacuumdb program.
Thanks Matt, might be time for an upgrade.
> Date: Tue, 5 Aug 2008 11:21:44 -0400
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> CC: pgsql-general@postgresql.org; [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Vacuum Vs Vacuum Full
>
>
Hi,
Is Heikki's Visibility Map patch included for the Postgresql 8.4 version
http://archives.postgresql.org/pgsql-hackers/2007-11/msg00142.php
If not whats the status of that patch? Im especially interested in the
index-only scan mentioned there!!!
Thanks
Sharmila
Hi,
here's a short example, the problem is at the end:
DROP TABLE IF EXISTS foo;
CREATE TABLE foo ( id SERIAL PRIMARY KEY, c2 VARCHAR NOT NULL );
INSERT INTO foo VALUES ( DEFAULT, 'foo' );
INSERT INTO foo VALUES ( DEFAULT, 'bar' );
INSERT INTO foo VALUES ( DEFAULT, 'baz' );
DROP TABLE IF EXISTS
hello everyone
I'm working on PostgreSQL XML Extension.
My system is windows xp professional sp2 and
PostgreSQL 8.3.3 and I am sure installed xml2 module.
I have a 2 colums table:
(frase di creazione tabella : create table ecc ecc)
I have a problem using a xpath function.
My query is:
SELEC
Hi,
I was trying to install postgreSQL with XML data type support. My OS is
ubuntu , kernel 2.6.15.. PostgresSQL version is 8.3.3 .I have libxml2 and
libxslt installed. I configured using
./configure --with-libxml --with-libxslt
configure went fine..
'make all' went fine
'make install' went fine.
Hi, if I have such a table:
t_ref_id t_data
1 'abc'
2 '321'
1 'ddd'
2 'xyz'
9 '777'
...
I want to get data with a special t_ref_id:
SELECT t_data FROM THETABLE WHERE t_ref_id = '1';
I must use a while loop to
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 configuration first and then our software.
Glyn Astill <[EMAIL PROTECTED]> writes:
>> Okay, so it is indeed the linker's fault. Now try plan
>> (a) --- can you
>> find a more up-to-date toolchain?
> Well I've tried looking in apt, and the latest package is the version I've
> got, (the toolchain is more than just gcc isn't it though?) is
Brian Maguire 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.
>
> --
> Sent via pgsql-general mailing list (pgsql-
> 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.bac
>
> Okay, so it is indeed the linker's fault. Now try plan
> (a) --- can you
> find a more up-to-date toolchain?
Well I've tried looking in apt, and the latest package is the version I've got,
(the toolchain is more than just gcc isn't it though?) is there another way to
get a more up to date
30 matches
Mail list logo
