Thank you, Alvaro.
Literal tab, that's one thing I never tried.
Yes, it works.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 5/31/10 8:58 PM, "Alvaro Herrera" wrote:
> Excerpts from Tena Sakai's message of lun may 31 21:36:41 -0400 2010:
>
>> But when I do this:
>> $ echo "select marker, p
Many thanks, Greg!
I got it to work by emulating what you wrote.
But I think you meant -A, not -At below.
>> psql -c "select name,setting from pg_settings limit 1" -d postgres -At
>> -F $'\t'
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 5/31/10 8:07 PM, "Greg Smith" wrote:
> Tena Sakai wrote
Excerpts from Tena Sakai's message of lun may 31 21:36:41 -0400 2010:
> But when I do this:
> $ echo "select marker, p, afreq from gallo.fbat_sdsdecode limit 10" | \
> > psql -P 'format=unaligned' -P 'fieldsep=\t' -t -f - musket
> (here the only change from the previous is the specification of
Tena Sakai wrote:
$ echo "select marker, p, afreq from gallo.fbat_sdsdecode limit 10" | \
> psql -P 'format=unaligned' -P 'fieldsep=\t' -t -f - musket
What's denoted as \t is not a tab character. It is a two character
sequence backslash followd by a t. I have tried all other possibilities
su
Hi Gabriele,
This isn’t strictly a psql problem, but please humor me.
I can do below from linux prompt:
$ echo "select marker, p, afreq from gallo.fbat_sdsdecode limit 10" | \
> psql -P 'format=unaligned' -P 'fieldsep=,' -t -f - musket
And get:
RS3094315,0.578121,0.735
RS3094315,0.578121,0
unregister
On Mon, May 31, 2010 at 9:59 AM, Tom Lane wrote:
> Dale Gallagher writes:
>> On 31 May 2010 13:10, Dale Gallagher wrote:
>>> I am now using strace on postgres startup and watching the filesystem
>>> during the creation of the database. So far, it seems that files in
>>> PGHOME/base/1
Dale Gallagher writes:
> On 31 May 2010 13:10, Dale Gallagher wrote:
>> I am now using strace on postgres startup and watching the filesystem
>> during the creation of the database. So far, it seems that files in
>> PGHOME/base/1234/ are appearing, but VERY slowly. Thus far it's taken
>> 7 minute
Maybe "test" is a reserved word.
Try test1.
From: pgsql-admin-ow...@postgresql.org [pgsql-admin-ow...@postgresql.org] on
behalf of Dale Gallagher [dale.gallag...@gmail.com]
Sent: Monday, May 31, 2010 3:50 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN]
Jamie Tufnell writes:
> Secondly, is there a companion tool to achieve this with pgbouncer?
> Note I have nothing against pgpool, just curious as we're already
> using pgbouncer in production.
If you mean distributing the read-only queries to more than one server
backend, you can use haproxy in T
On 31 May 2010 13:10, Dale Gallagher wrote:
> I am now using strace on postgres startup and watching the filesystem
> during the creation of the database. So far, it seems that files in
> PGHOME/base/1234/ are appearing, but VERY slowly. Thus far it's taken
> 7 minutes and 92 files have been creat
On 31 May 2010 12:50, Dale Gallagher wrote:
> When running the command 'create database test' as user postgres from
> within psql, the command hangs indefinitely.
I am now using strace on postgres startup and watching the filesystem
during the creation of the database. So far, it seems that files
Hello
When running the command 'create database test' as user postgres from
within psql, the command hangs indefinitely.
I've installed 8.4.4 from source on a Slackware 13.0 box with kernel
2.6.29, GCC 4.3.3 and OpenSSL 0.9.8n with self-signed certificates.
Built with ./configure --prefix=/opt/p
Dear Iñigo Martinez Lasala，
Thank you for you information !
_
发件人: Iñigo Martinez Lasala [mailto:imarti...@vectorsf.com]
发送时间: 2010年5月31日 15:52
收件人: 黄永卫
抄送: 'pgsql-admin'
主题: Re: 答复: About "Context-switch storm" problem
1- Of course, we could. Problem appeared in bot
1- Of course, we could. Problem appeared in both 8.1.8 and 8.1.15 after
an initial upgrade.
Today database is not online due to a migration to another technology.
It's not our database (a customer one) so we have no access to it at
this moment.
2- One of the major on-line shops of Spain. This onl
14 matches
Mail list logo
