Hi all
Im using postgresql-8.0.3-1.
I need to create a new user in postgresql with password ..But it should not
prompt me to get the password ..ie only through command line I've to give
the password as input
Steps i had done are as follows
[EMAIL PROTECTED] ~]# su postgres -c "createuser -A -d gl
Actually I just noticed that all of the permissions on the tables that don't
have an edit button have an asterisk next to the permission type,
while on the tables with the edit button the permissions are exactly the
same, but there is no asterisk.
This is the clue I was looking for, though I don't
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Suresh Gupta VG
Sent: Tuesday, 19 February 2008 21:17
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Log details are displaying on the console
> All the logging details of pgsql are displaying on the consol
On Feb 19, 2008 3:04 PM, Carol Walter <[EMAIL PROTECTED]> wrote:
> I went to the page. It said the OS is Linux. Is there anything for
> Solaris. I've got Solaris 10.
It looks like it's just some C code, a shell file, and some sql
scripts. It should compile and run fine on any postgresql supporte
I notice when browsing some of the tables in phppgadmin some of them have an
"Actions" column that includes buttons for "Edit" and "Delete" while other
tables do not have that as an additional column when viewing them in
phppgadmin.
Does someone know the difference between these 2 instances and mo
I went to the page. It said the OS is Linux. Is there anything for
Solaris. I've got Solaris 10.
Carol
On Feb 19, 2008, at 3:19 PM, Scott Marlowe wrote:
On Feb 19, 2008 12:47 PM, Carol Walter <[EMAIL PROTECTED]> wrote:
Hello,
I have to load a very large database. Is there a command that
On Feb 19, 2008 12:47 PM, Carol Walter <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have to load a very large database. Is there a command that can
> load data in bulk faster than the copy command does?
pg_bulkload
http://pgfoundry.org/projects/pgbulkload/
I've not used it, but have seen it mentio
> Andrew Sullivan wrote:
>
> On Tue, Feb 19, 2008 at 01:47:01PM -0500, Carol Walter wrote:
> > I have to load a very large database. Is there a command that can
> > load data in bulk faster than the copy command does?
>
> No.
>
There was a thread a while back regarding this.
http://archives.post
On Tue, Feb 19, 2008 at 01:47:01PM -0500, Carol Walter wrote:
> I have to load a very large database. Is there a command that can
> load data in bulk faster than the copy command does?
No.
A
---(end of broadcast)---
TIP 5: don't forget to incre
On Tue, Feb 19, 2008 at 12:59:55PM -0500, Douglas J Hunley wrote:
> I seemed to have walked into a "spirited" debate at work today, so I'm
> turning
> to the authorities to get it resolved. Why would one choose -Ft over -Fc (or
> vice-versa) when doing pg_dump? Is there truly any difference of n
On Tuesday 19 February 2008 13:12:23 Tom Lane wrote:
> I can't really imagine any reason to choose -Ft, except wanting to do
> post-processing of the dump with command-line tools. -Ft's lack of
> compression and limitations on component size are sufficient reasons
> not to choose it without a spec
Hello,
I have to load a very large database. Is there a command that can
load data in bulk faster than the copy command does?
Carol Walter
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Douglas J Hunley <[EMAIL PROTECTED]> writes:
> I seemed to have walked into a "spirited" debate at work today, so I'm
> turning
> to the authorities to get it resolved. Why would one choose -Ft over -Fc (or
> vice-versa) when doing pg_dump?
I can't really imagine any reason to choose -Ft, excep
I seemed to have walked into a "spirited" debate at work today, so I'm turning
to the authorities to get it resolved. Why would one choose -Ft over -Fc (or
vice-versa) when doing pg_dump? Is there truly any difference of note
(outside the formats themselves)?
Thanks
--
Douglas J Hunley (doug a
libra dba wrote:
Hello all,
Thanks for your response. The example shown by Charles Duffy, is quite
impressive. Actually i built my replication based on this.
But, i want to test the failover. In the example shown by Charles, mentions
'a trigger file' as it says:
--
Hello all,
Thanks for your response. The example shown by Charles Duffy, is quite
impressive. Actually i built my replication based on this.
But, i want to test the failover. In the example shown by Charles, mentions
'a trigger file' as it says:
---
Nalini, your quiet correct that, listen_addresses = * , implies that
your server must listen on all network interfaces. Dan does not have an
issue with his server listening on all network interfaces. His issue is
to restrict the client machines that connect to his server.
Now, he is trying to
Hi All,
All the logging details of pgsql are displaying on the console itself.
Pls see the below output. Is there any option in the configuration files
to disable it.?
bash-2.05$ ps -ef |grep postgres
pgsql 17915 17913 0 12:51:13 ?0:00
/db1/postgresql/bin/postgres -D /db1/postg
* in postgresql.conf actually denotes the network interfaces on the machine on
which the postgresql server is running.
If you wish to limit access to certain IPs do it in pg_hba.conf.
- Original Message -
From: "Mehlape, Makgati" <[EMAIL PROTECTED]>
Date: Tuesday, February 19, 2008 3:12
Hi.
I think setting Listen_address to *, does not necessary allows all
connections but allows your PostgreSQL server to support TCP/IP
connections. So, leave it as it is.
In order to apply control over what machine IP addresses should connect
remotely to your server; specify the IP addresse
Hi list,
I am using postgresql 8.2 on Ubuntu Gutsy. I am attempting to connect to my
database on one computer from another computer on my network. I can connect
to the database if I have:
listen_addresses = '*'
in my postgresql.conf file. But I can't connect if I have:
listen_addresses = 'local
On Tue, 2008-02-19 at 09:53 +0530, Praveen Kumar (TUV) wrote:
> Go through this below mentioned link
>
>
>
> http://archives.postgresql.org/sydpug/2006-10/msg1.php
I think people should be reading the manual, rather than reading an old
email. We have improved and corrected the manual, but
22 matches
Mail list logo
