Hello all,
I got surprised by this message:
-
The program "pg_dump" is needed by pg_dumpall but was not found in the
same directory as "/usr/bin/pg_dumpall".
Check your installation.
--
It's quite strange because I'm quite t
Hi,
How I configure password to postgres user in Linux?
I'm using trust, but I needing configure password in database.
Thanks!
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index s
On 31 out, 07:33, [EMAIL PROTECTED] (João Paulo Zavanela) wrote:
> Hi,
>
> How I configure password to postgres user in Linux?
> I'm using trust, but I needing configure password in database.
>
> Thanks!
>
> ---(end of broadcast)---
> TIP 9: In versio
Hi people. I have 2 databases named as follows:
1) company_a
2) company_b
These two databases do not have the same ER model. However, I want to
access tables on "company_a" there are in "company_b". I want to use
them as local tables (as other databases like Sybase allows, since you
have opened
On 31 out, 06:56, [EMAIL PROTECTED] (Joao Miguel
Ferreira) wrote:
> Hello all,
>
> I got surprised by this message:
>
> -
> The program "pg_dump" is needed by pg_dumpall but was not found in the
> same directory as "/usr/bin/pg_dumpall".
> Check your installation
Joao Miguel Ferreira <[EMAIL PROTECTED]> writes:
> This is what I do:
> system("su postgres -c \"pg_dumpall --clean > some_file\"");
This is going to try to find pg_dumpall in whatever PATH is currently
active within the script --- maybe there's something bogus about that
path? Personally I'd use
>> Hi,
>>
>> How I configure password to postgres user in Linux?
>> I'm using trust, but I needing configure password in database.
>>
>> Thanks!
>>
>> ---(end of broadcast)---
>> TIP 9: In versions below 8.0, the planner will ignore your desire to
>>
On Tue, Oct 30, 2007 at 01:58:29PM -0500, Decibel! wrote:
> Does anyone have a .vim file that takes dollar quoting into account?
> I've tried the one mentioned at
> http://archives.postgresql.org/pgsql-general/2006-04/msg01266.php , but
> it doesn't appear to understand dollar quotes.
The magic ap
The Amazon Dynamo framework is going to replace RDBMS?
http://www.readwriteweb.com/archives/amazon_dynamo.php
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
Il Wednesday 31 October 2007 11:47:46 T.J. Adami ha scritto:
> Hi people. I have 2 databases named as follows:
>
> 1) company_a
>
> 2) company_b
>
>
> These two databases do not have the same ER model. However, I want to
> access tables on "company_a" there are in "company_b". I want to use
> them
We are currently migrating from Sybase's ASA 9/10 to PostGres 8.2.4. One of
the features that is really nice in ASA is the ability to add the attribute
hidden to a Create procedure, Create function and Create trigger. Essentially
what this does is encrypt the code so that if anyone or any util
Hi Oisin,
> The only similar issues I have seen was where the user was created for
> the DB with the user must change password at next login option and this
> caused some issues?
I checked and I have the option "never change password checked". However, for
the user I used for the previous 8.
I don't understand, where I do it?
>-- Mensagem Original --
>From: "Martin Gainty" <[EMAIL PROTECTED]>
>To: João Paulo Zavanela <[EMAIL PROTECTED]>
>Subject: Re: [GENERAL] active connections
>Date: Mon, 30 Oct 2000 16:51:30 -0500
>
>
>ps aux | grep postgres
>
>M--
>- Original Message -
>F
> | system("su postgres -c \"pg_dumpall --clean > some_file\"");
>
> I'd try "su - postgres ..."; this will use postgres' environment here.
>
That was a good one but still didn't work
> | this is run from within a Perl module called from within a Perl script.
> |
> | I've tried the same
2007/10/30, Decibel! <[EMAIL PROTECTED]>:
> Does anyone have a .vim file that takes dollar quoting into account?
> I've tried the one mentioned at
> http://archives.postgresql.org/pgsql-general/2006-04/msg01266.php , but
> it doesn't appear to understand dollar quotes.
dollar quoting is mostly use
On Mittwoch, 31. Oktober 2007, Joao Miguel Ferreira wrote:
| I got surprised by this message:
|
| -
| The program "pg_dump" is needed by pg_dumpall but was not found in the
| same directory as "/usr/bin/pg_dumpall".
| Check your installation.
| --
On 10/31/07, João Paulo Zavanela <[EMAIL PROTECTED]> wrote:
> >> Hi,
> >>
> >> How I configure password to postgres user in Linux?
> >> I'm using trust, but I needing configure password in database.
> >>
> >> Thanks!
> >>
> >> ---(end of broadcast)---
João Paulo Zavanela <[EMAIL PROTECTED]> schrieb:
> I don't understand, where I do it?
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?
Please no top-posting, it's hard to re
João Paulo Zavanela <[EMAIL PROTECTED]> writes:
> Thanks, but I need configure password to connect to server!
> Now the pg_hba.conf is trust, I need change to passwd.
> Changing the file to passwd, I don't know how configure password to connect!
Set pg_hba.conf to 'trust', connect and use ALTER U
I wrote a little script to individually back up table schemas, table
data and then vacuum the table and it works nicely but I wanted a way to
query a database and get a text file with just the table names and
cannot figure out a way to do that.
my script looks like this...
(all I want is to get a
On Wed, 2007-10-31 at 08:01 -0700, Craig White wrote:
> I wanted a way to
> query a database and get a text file with just the table names and
> cannot figure out a way to do that.
This should do the trick:
$ psql -Atc "select table_schema||'.'||table_name from
information_schema.tables"
-Reece
On 31/10/2007, T.J. Adami <[EMAIL PROTECTED]> wrote:
> Hi people. I have 2 databases named as follows:
>
> 1) company_a
>
> 2) company_b
>
>
hello
you can access others databases via dblink
look to contrib
Pavel Stehule
---(end of broadcast)---
TI
Il Wednesday 31 October 2007 15:39:55 mgould ha scritto:
> We are currently migrating from Sybase's ASA 9/10 to PostGres 8.2.4. One
> of the features that is really nice in ASA is the ability to add the
> attribute hidden to a Create procedure, Create function and Create trigger.
> Essentially wh
mgould wrote:
> We are currently migrating from Sybase's ASA 9/10 to PostGres
> 8.2.4. One of the features that is really nice in ASA is the
> ability to add the attribute hidden to a Create procedure,
> Create function and Create trigger. Essentially what this
> does is encrypt the code so t
On 10/31/07, Reg Me Please <[EMAIL PROTECTED]> wrote:
> Il Wednesday 31 October 2007 11:47:46 T.J. Adami ha scritto:
> > The question is: can I do this using remote database servers
> > (different hosts)? If does not, can I do it at least on local
> > databases on the same server?
> >
> As far as
On 31 out, 12:01, [EMAIL PROTECTED] (Craig White) wrote:
> I wrote a little script to individually back up table schemas, table
> data and then vacuum the table and it works nicely but I wanted a way to
> query a database and get a text file with just the table names and
> cannot figure out a way t
On 31 out, 11:00, [EMAIL PROTECTED] ("Phoenix Kiula") wrote:
> The Amazon Dynamo framework is going to replace RDBMS?
>
> http://www.readwriteweb.com/archives/amazon_dynamo.php
>
> ---(end of broadcast)---
> TIP 4: Have you searched our list archives?
On Wednesday 31 October 2007 T.J. Adami's cat, walking on the keyboard, wrote:
> The question is: can I do this using remote database servers
> (different hosts)? If does not, can I do it at least on local
> databases on the same server?
I guess the dblink module could help you.
Luca
---
mgould <[EMAIL PROTECTED]> writes:
> We are currently migrating from Sybase's ASA 9/10 to PostGres 8.2.4.
> One of the features that is really nice in ASA is the ability to add
> the attribute hidden to a Create procedure, Create function and
> Create trigger. Essentially what this does is encryp
I'm testing PostgreSQL 8.3-beta 1, and still do not fix this message:
"createdb: database creation failed: ERROR: encoding LATIN1 does not
match server's locale Portuguese_Brazil.1252
DETAIL: The server's LC_CTYPE setting requires encoding WIN1252."
On PostgreSQL 8.2.5 I'm able to create data d
Craig White wrote:
I wrote a little script to individually back up table schemas, table
data and then vacuum the table and it works nicely but I wanted a way to
query a database and get a text file with just the table names and
cannot figure out a way to do that.
my script looks like this...
(al
There's not bulletproof way, in my opinion.
If they copy the whole DB structure *and* the object binaries they'll
have the very same functionalities!
Il Wednesday 31 October 2007 16:13:23 Douglas McNaught ha scritto:
> mgould <[EMAIL PROTECTED]> writes:
> > We are currently migrating from Sybase'
On Wed, Oct 31, 2007 at 08:01:41AM -0700, Craig White wrote:
> I wrote a little script to individually back up table schemas, table
> data and then vacuum the table and it works nicely but I wanted a
> way to query a database and get a text file with just the table
> names and cannot figure out a w
>João Paulo Zavanela wrote:
>>
>> The file pljava.dll exist in directory, why this error?
>> Someone can help me?
>
>PL/Java has it's own mailing list here:
>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>I think it is still active, but I'm not sure. Sorry, I'm short on time.
> Searc
2007/10/31, Craig White <[EMAIL PROTECTED]>:
> I wrote a little script to individually back up table schemas, table
> data and then vacuum the table and it works nicely but I wanted a way to
> query a database and get a text file with just the table names and
> cannot figure out a way to do that.
On 10/31/07, mgould <[EMAIL PROTECTED]> wrote:
>
>
> We are currently migrating from Sybase's ASA 9/10 to PostGres 8.2.4. One of
> the features that is really nice in ASA is the ability to add the attribute
> hidden to a Create procedure, Create function and Create trigger.
> Essentially what this
On 10/29/07, Kalra, Ashwani <[EMAIL PROTECTED]> wrote:
>
> Hi,
> In our thick client application, I want to update the schema on the
> user's machine automatically as normal software update process using JNLP
> etc
>
> We will be using Eclipser RCP. Is it possible?
>
Sure. IF nothing else, you
On 10/31/07, Douglas McNaught <[EMAIL PROTECTED]> wrote:
> The only bulletproof way to do this currently is to write all your
> stored functions in C and load them as a shared library.
Well, as I pointed out in my post, even that's not bullet-proof. As
long as decompilers / debuggers etc... exis
"T.J. Adami" <[EMAIL PROTECTED]> writes:
> I'm testing PostgreSQL 8.3-beta 1, and still do not fix this message:
> "createdb: database creation failed: ERROR: encoding LATIN1 does not
> match server's locale Portuguese_Brazil.1252
> DETAIL: The server's LC_CTYPE setting requires encoding WIN1252.
On 10/31/07, T.J. Adami <[EMAIL PROTECTED]> wrote:
> On 31 out, 11:00, [EMAIL PROTECTED] ("Phoenix Kiula") wrote:
> > The Amazon Dynamo framework is going to replace RDBMS?
> >
> > http://www.readwriteweb.com/archives/amazon_dynamo.php
>
> This is another idea trying to put down RDBMS. I really thi
Alvaro Herrera wrote:
> Bruce Momjian wrote:
> >
> > Is this item closed?
>
> No, it isn't. Please add a TODO item about it:
> * Prevent long-lived temp tables from causing frozen-Xid advancement
>starvation
Thanks. Added to TODO.
--
Bruce Momjian <[EMAIL PROTECTED]>http://mo
Thanks all. In the open source community there seems to be more talent to
"hack" than in other environments. Once I told ASA to set the "hidden"
attribute, I've not had any problems with this, at least that I've heard of. I
was hoping that I'd be able to keep others out of the database totally
Title: can someone please tell me how to unsubscribe from this group - thanks
can someone please tell me how to unsubscribe from this
group - thanks
Regards,
Ian
Ian Goldsmid
www.semanticdiscoverysystems.com
When I run a query, and the number of lines exceeds what the screen can
hold, the results seem to get piped into "more" (or "less"). How can I
turn that off and just have everything stream out without stopping? I
tried -echo-all, but that doesn't seem to do the trick.
Thanks in Advance !
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> On 10/31/07, Douglas McNaught <[EMAIL PROTECTED]> wrote:
>
>> The only bulletproof way to do this currently is to write all your
>> stored functions in C and load them as a shared library.
>
> Well, as I pointed out in my post, even that's not bullet-p
Joao Miguel Ferreira <[EMAIL PROTECTED]> writes:
> This is what I do:
> system("su postgres -c \"pg_dumpall --clean > some_file\"");
> this is run from within a Perl module called from within a Perl script.
> I've tried the same command directlly on the shell and it works fine.
> But from the pe
Tom Lane wrote:
"Michael Harris" <[EMAIL PROTECTED]> writes:
The tip is ''kill -9' the postmaster', which has two important
differences to the scenario I just described:
1) kill -9 means the OS kills the process without allowing it to clean
up after itself
2) The postmaster is the master post
Hello,
We had a great time at the conference and subsequent party. If you are
ever in PDX and want some great food and interesting accommodations I
strongly suggest the Paramount Hotel and Dragon Fish cafe. They treated
all of us very well and had great food!
The conference did well above expecta
=?ISO-8859-1?Q?Christian_Schr=F6der?= <[EMAIL PROTECTED]> writes:
> But then, when I tried to reconnect to the database, I received the
> following message:
> <2007-10-31 22:50:01 CET - chschroe> FATAL: the database system is in
> recovery mode
> Ok, you wrote "Postgres will recover automaticall
Tom Lane wrote:
Ok, you wrote "Postgres will recover automatically", but could this take
several minutes?
Yeah, potentially. I don't suppose you have any idea how long it'd been
since your last checkpoint, but what do you have checkpoint_timeout and
checkpoint_segments set to?
I did
On 30/10/2007, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
> ok, then you have to formalize many things - how long should be excerpts,
> how much excerpts to show, etc. In tsearch2 we have get_covers() function,
> which produces all excerpts like:
>
> =# select get_covers(to_tsvector('1 2 3 4 5 3 4 ab
Hi list,
I have a strange problem: When I connect to one of my databases, the
current_user immediatly changes without any interaction from my side.
This is what I do:
[EMAIL PROTECTED]:~> psql -h db2 testdb
Welcome to psql 8.2.5, the PostgreSQL interactive terminal.
Type: \copyright for dist
On Wed, Oct 31, 2007 at 05:18:58PM -0400, mgould wrote:
> Thanks all. In the open source community there seems to be more
> talent to "hack" than in other environments.
I think we're just much more honest about what the technology is
really capable of. None of us is likely to actually bother bre
=?ISO-8859-1?Q?Christian_Schr=F6der?= <[EMAIL PROTECTED]> writes:
> I have a strange problem: When I connect to one of my databases, the
> current_user immediatly changes without any interaction from my side.
That's bizarre. Do you have anything in ~/.psqlrc? I'm also wondering
(though too laz
CREATE ROLE db_users
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
ALTER ROLE db_users SET search_path=mydb, public;
When I create a login,
CREATE ROLE oli LOGIN
ENCRYPTED PASSWORD 'mXXX'
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
ALTER ROLE oliver SET search_path=xmms; < I have to set
On Thu, 2007-11-01 at 00:02 -0400, Tom Lane wrote:
> Ow Mun Heng <[EMAIL PROTECTED]> writes:
> > Why is this such or is this an intended feature?
>
> No, there is no intention that ALTER ROLE SET values be inherited ---
> what you get is just what is attached to the role you logged in as.
> What
Ow Mun Heng <[EMAIL PROTECTED]> writes:
> Why is this such or is this an intended feature?
No, there is no intention that ALTER ROLE SET values be inherited ---
what you get is just what is attached to the role you logged in as.
What would you do with conflicting sets from different inherited role
Tom Lane wrote:
=?ISO-8859-1?Q?Christian_Schr=F6der?= <[EMAIL PROTECTED]> writes:
I have a strange problem: When I connect to one of my databases, the
current_user immediatly changes without any interaction from my side.
That's bizarre. Do you have anything in ~/.psqlrc? I'm also wo
am Wed, dem 31.10.2007, um 17:14:02 -0400 mailte Gauthier, Dave folgendes:
> When I run a query, and the number of lines exceeds what the screen can hold,
> the results seem to get piped into ?more? (or ?less?). How can I turn that
> off
> and just have everything stream out without stopping?
59 matches
Mail list logo
