Hi,
Sorry if the question is too preliminary.
I want to know if we can login to the database running at the server from
any place. I know I have to allow such access thru pg_hba.conf file. But how
do I connect to the database.
Can I do something like :
pgsql database@serverIP where serverIP ca
Jeremy Buchmann <[EMAIL PROTECTED]> writes:
> I have a weird situation here...I'm trying to drop a table, but it tells me
> that "Relation 'xxx' inherits 'mytable'". So I renamed mytable to
> myoldtable and created a new mytable. Now, the new mytable is missing the
> fields I was trying to a
>
> > I'm using pgsql 6.5.3 on Linux 2.2
>
> Time to upgrade...
>
> regards, tom lane
>
I am using 6.5 too. The reason is some data type are gone. e.g. datetime. If do
so, I have to modify my application.
Ciao,
Banghe
---(end of broadcast)--
bangh <[EMAIL PROTECTED]> writes:
> I am using 6.5 too. The reason is some data type are
> gone. e.g. datetime. If do so, I have to modify my application.
?? This still works:
regression=# create table foo (f1 datetime);
CREATE
regards, tom lane
---
Jeremy Buchmann <[EMAIL PROTECTED]> writes:
> So it is one of those temp tables...now if I delete those tables with the
> allow-system-table-mods switch, will that still correct the pg_inherits
> table so that the dependency no longer exists?
Yes, you should be okay once you've dropped the leftov
Jeremy Buchmann <[EMAIL PROTECTED]> writes:
> Okay great, but how do I know what tables I need to drop if it just gives me
> a number? That 'xxx' is just some number like '8892659'. Where is the
> mapping from number->name?
select relname from pg_class where oid = '8892659';
More recent ve
> Jeremy Buchmann <[EMAIL PROTECTED]> writes:
>> Okay great, but how do I know what tables I need to drop if it just gives me
>> a number? That 'xxx' is just some number like '8892659'. Where is the
>> mapping from number->name?
>
> select relname from pg_class where oid = '8892659';
>
> M
On Sat, 17 Feb 2001, bangh wrote:
> > > I'm using pgsql 6.5.3 on Linux 2.2
> >
> > Time to upgrade...
> >
> > regards, tom lane
> >
>
> I am using 6.5 too. The reason is some data type are gone. e.g. datetime. If do
> so, I have to modify my application.
Is there anythin
> Jeremy Buchmann <[EMAIL PROTECTED]> writes:
>> I have a weird situation here...I'm trying to drop a table, but it tells me
>> that "Relation 'xxx' inherits 'mytable'". So I renamed mytable to
>> myoldtable and created a new mytable. Now, the new mytable is missing the
>> fields I was tryin
vijayendra mohan agrawal wrote:
> how do I connect to the database.
psql -h host [-p port] [-U username] database_name
OR
psql -h host [-p port] database_name username
psql --help for details of all the options.
One thing to remember - if you try to login from the database machine
and if yo
when I am logging on Postgres i haven't to give a password
How can I do in order to have one ?
when I want to pg_dump a database with user postgres, this error appears :
permisson not allowed
whereas with user root it is good
how can i resolve this problem ?
THANKS
__
I want to view events about my databases on a log file
In /var/lib/pgsql/data I have a log directory 'syslog' which contains no files
how can I do in order to have events in a file in this directory ?
Otherwise, what is the better method to view events in a log file ?
I have tryed to configure
On Wed, 25 Apr 2001, [EMAIL PROTECTED] wrote:
> when I am logging on Postgres i haven't to give a password
>
> How can I do in order to have one ?
Look at the pg_hba.conf file (normally in $PGDATA directory).
You'll want to change the 'trust' to 'password' for local users.
--
Joel Burton
On Wed, 25 Apr 2001, [EMAIL PROTECTED] wrote:
> I have tryed to configure pg_options for logs but it was not successful
Normally, you want to up your debug level in pg_options.
Can you tell us more specifically what you've tried to do?
--
Joel Burton <[EMAIL PROTECTED]>
Director of Informati
I am trying to create a new database in an alternate location using
'initlocation' and 'createdb'.
The 'initlocation' utility appears to work, but 'createdb' always fails with the
following error:
"ERROR: The database path 'PGDATA2' is invalid. This may be due to a character
that is not allowed
"[EMAIL PROTECTED]" wrote:
>
> I want to view events about my databases on a log file
For version 7.0.x in the RPM distribution:
1.) Enable syslog in pg_options (see documentation on the levels
necessary)
2.) Add a line to /etc/syslog.conf for local1 to go to the file you
want.
3.) R
Aaron Brown <[EMAIL PROTECTED]> writes:
> I put the absolute path of the new location in the PGDATA2 environment
> variable, which is visible to the postmaster because the variable is
> set at system startup in /etc/profile.local.
Are you *sure* about that? The described symptoms certainly sound
17 matches
Mail list logo
